Comments by Member 9861478

Member 9861478 23-Feb-14 21:38pm View

Thank you so much!!!

Member 9861478 2-Dec-13 4:22am View

Your post is really valuable, I find more information in this link..Thank you so much

Member 9861478 9-Oct-13 11:59am View

Sorry about that, sure.

Member 9861478 27-Sep-13 1:50am View

Hi Ganesh. My senario is different already tried those before. I am able to export to excel successfully. I am looking for Password protected for the excel after exporting to excel.
Here is my code.

Protected Sub btnPayroll_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnPayroll.Click
Response.Clear()
Response.AddHeader("content-disposition", "attachment; filename=Monthly Payroll.xls")
Response.Charset = ""
Response.ContentType = "application/vnd.xls"
Dim stringWrite As New System.IO.StringWriter()
Dim htmlWrite As System.Web.UI.HtmlTextWriter = New HtmlTextWriter(stringWrite)

Dim FilePathName As String = Request.PhysicalPath
Dim fileInfo = New IO.FileInfo(FilePathName)
fileInfo.IsReadOnly = True

GridView1.HeaderRow.Style.Add("background-color", "#99CCFF")

GridView1.RenderControl(htmlWrite)
Response.Write(stringWrite.ToString())
Response.[End]()
End Sub

Member 9861478 19-Sep-13 2:37am View

Thank you for the answer. I am working on my local machine not yet in server when I posted. I just now checked in Server. Is there any property to apply Readonly to excel?

Member 9861478 6-Sep-13 10:41am View

No worries. Thank you. My mistake.

Member 9861478 6-Sep-13 10:20am View

Oops..I forgot to mention. I am looking for Web applications..Semms you suggested for windows applications.

Member 9861478 12-Aug-13 3:23am View

Could you please guide through best as you might know better.. really appreciated for quick response.
Thanks,

Member 9861478 12-Jul-13 5:54am View

Thank you for your solution But I found a solution as per my requirement.

Member 9861478 3-Jul-13 3:24am View

okay. Thank you

Member 9861478 3-Jul-13 3:20am View

It seems the grid display only 100 records. As per the limitations we can't display further. for further we have to purchase the product..

Refer here
http://www.obout.com/inc/ultimate.aspx

Member 9861478 3-Jul-13 2:10am View

Excellent! Seems you are so smart in answering typical questions.

Member 9861478 3-Jul-13 0:45am View

Hi,
Sorry for not making clear. There are total 10 columns in grid. I wanted to export to excel only 7 columns. Please let me know if you need anymore clarification.

Member 9861478 27-Jun-13 23:51pm View

it's working for me!!

Member 9861478 20-Jun-13 3:01am View

Hi Andri,

Thank you for your response,,but this is not what I want.. I want to remove only last slash in corrupted data.

Member 9861478 13-Jun-13 2:44am View

Please let me know if you need anymore information in this concern. I am sorry for my ignorance....if I don't make any sense in this situation...

Member 9861478 13-Jun-13 0:46am View

Okay. But I have bind the dropdown list directly in the UI..like: There is an option to choose data source.
1. I have checked value with break point and the value is coming up but it is not showing result in the end....

Member 9861478 13-Jun-13 0:10am View

FYI.. I am getting the values of Dropdown from one of columns in the same table..

Member 9861478 13-Jun-13 0:10am View

Not working still...I just replaced dropdown with Textbox..Searching criteria is working with Textbox but not with Dropdown

Member 9861478 13-Jun-13 0:07am View

Thank you....will try an let you know...Thank you for your patience.

Member 9861478 13-Jun-13 0:04am View

It is absolutely working when I use Text box as Search in UI...but not with Dropdown list as search...

Member 9861478 12-Jun-13 23:55pm View

It is absolutely working....when I use Text box as Search in UI...but not with Dropdown list as search...

Member 9861478 12-Jun-13 23:54pm View

Sure..

Create procedure [dbo].[searchCriteriaSP]
(
@input varchar(250)
)
as
BEGIN
Select * from Employees
where EmployeeName=@input
END

Member 9861478 12-Jun-13 23:19pm View

Thank you for your response.still not working..but no error though.

Member 9861478 12-Jun-13 4:33am View

Excellent!!!!U r super!!!

Member 9861478 6-Jun-13 4:45am View

Okay..Marked it..

Member 9861478 6-Jun-13 4:44am View

THANK YOU......

Member 9861478 6-Jun-13 4:02am View

Thank you for your motivation. I don't forget this..

Member 9861478 6-Jun-13 3:59am View

Just have a doubt on my assumption...

Is this below way to identify a column and assign it to a variable

Dim dtDOJ As DateTime = Convert.ToDateTime(e.Row.Cells(5).Text)

I assume the description of the step is:
I declared a date variable and assigned it with fifth column which is date column in my project..Please correct me if i am wrong..

Member 9861478 6-Jun-13 3:53am View

Thanks. Sorry for my ignorance..I am trying that..Really helpful..

Member 9861478 6-Jun-13 3:47am View

Surprisingly, The label id is not getting inherited in code behind..any idea?

Member 9861478 6-Jun-13 3:14am View

Thank you . I will try and let you know....Really appreciated.

Member 9861478 6-Jun-13 3:10am View

I searched in google and found to add Label..May that helps for next steps sorry abt that...

Member 9861478 6-Jun-13 3:03am View

Oops! Thank you for probing. I haven't added any textbox or label. Really new to use grid and I am in a migration project..Could you please guide me on this?

Member 9861478 6-Jun-13 2:58am View

Yes Abhinav. The code is not working..seems no error but no result.

Member 9861478 31-May-13 5:54am View

Hey giys found the solution.......

TextBox1.Text = Calendar2.SelectedDate.ToString("dd-MMM-yyyy");

DateTime currentDate;
currentDate = Convert.ToDateTime(TextBox1.Text);
TextBox2.Text = currentDate.AddYears(1).ToString("dd/MM/yyyy");

Member 9861478 31-May-13 4:36am View

Thank you for your quick response.. I am looking for the year increment by 1 ...

Here is the code for your reference....but it is not working...

protected void Calendar2_SelectionChanged(object sender, EventArgs e)
{
TextBox1.Text = Calendar2.SelectedDate.ToString();

DateTime currentDate;
currentDate = Convert.ToDateTime(TextBox1.Text);
currentDate.AddYears(1);
TextBox2.Text = currentDate.ToString("dd-MMM-yyyy");
}

Member 9861478 3-May-13 1:50am View

Deleted

Guys!! Got some issues still...don't know tried already these things...Hmmm...Any fundamental things we can go about it....The links are superb but already tried.

Member 9861478 19-Apr-13 2:49am View

Deleted

I am really sorry about that. I didn't put in the question what I mean? Really sorry!!!!

My questions is " Basically, What is ERP, Why do we need that and Does it a technology or something " Realy sorry if I ask silly questions but I wanna take a course while having my studies..Thanks in advance. I am not well experienced like u if u r....pls explain n another way...Thanks in advance/...

Member 9861478 19-Apr-13 2:35am View

Deleted

Nevermind. I will research more...thanks anyways.. I just wanted to see how people correlate things. Do u have any descriptive statement how cal u correlate ERP? Else tnx...

Member 9861478 18-Apr-13 23:16pm View

It worked finally....U rocz. Happy coding!!!!

Member 9861478 17-Apr-13 3:08am View

welcome!!

Member 9861478 17-Apr-13 3:06am View

Excellent!!! It works..Happy coding..

Member 9861478 17-Apr-13 2:30am View

tnx..but still showing error!!

Member 9861478 12-Apr-13 1:48am View

Deleted

Thank you for your link. Yes, I am going to contact them. again thank you for your response.

Member 9861478 10-Apr-13 3:42am View

Hi Kumar,

Thank you got your quick response. Thank you fr your suggestion. I can use it in future may be.. as i need to submit assignment tomorrow. can you please help me with normal file upload control?...

Regards,
Jack.

Member 9861478 8-Apr-13 21:30pm View

Thank you. It worked. I am on vocation and didn't see your answer. Thanks anyways

Comments by Member 9861478 (Top 47 by date)