I'm currently struggling to upload the Excel sheet data to the SQL Server using .Net. Please help me in provide the source code for it. I'll be very thnakful for the timely help....

Sample code :
[code=c#]
string Connstring = @"Server=IN4410 9369\SQLExpress ; Database=MATool ;Trusted_Connec tion=Yes";
conn = new SqlConnection(C onnstring);
string SQLcnn = "SELECT Id,Analyst,Vend orType,Site,Leg al,QAD_Code,Pha se_II_Audit,QAD _Status,Code_St atus,Pop_Form_T AT,Rec_Form_TAT ,TAT_AP,EDI_TAT ,VMTAT,Audited_ By,VM_FTT,TOE,V M_Error_Desc,Ca tegory,Fatal,No n_Fatal,PhaseII _AuditStatus,Au dit_Status,Audi t_Compl_Date,Au dit_Compl_Time, Audit_TAT...

Thanks for providing me the coding, i'll work on it and let you know the status. by monday.

Thanks a lot.
Have a great weekend.

I've solved it by myself. Thanks for the help.

I retrieved primary key value when i clicked on the grid and then transfered the Primary key value using session to another page and completed my issue.

Please let me know, is this a correct way.

Can you please provide me a sample code how to send Emails from C#.

Thanks.
Dijo.

Hi Guys,

I'm new to C#.Net

I’m Using a GridView control in my project. When I click on Edit command that particular row values needs to be displayed in another page. Say (Add and Modify tracker)

How do I invoke another page on the Edit click?

Please help me.
I'll will be thankful for your timely help.

Divya.