inserting excel rows to database through gridview

yesubabu k

Sir,

I am facing a problem with inserting

i hevea excel file wth 5 columns so those 5 are save in to my database in windows application

DataTable dt = dbFunctions.getTable("pr_Upload_AMC_Details '" + dataGridView1.Rows[i].Cells[1].Value.ToString() + "',''" + dataGridView1.Rows[i].Cells[2].Value.ToString() + "'',''" + dataGridView1.Rows[i].Cells[3].Value.ToString() + "'','" + DateTime.Parse(dataGridView1.Rows[i].Cells[4].Value.ToString()).ToString("dd-MMM-yyyy") + "',''" + DateTime.Parse(dataGridView1.Rows[i].Cells[5].Value.ToString()).ToString("dd-MMM-yyyy") + "'','" + dataGridView1.Rows[i].Cells[6].Value.ToString() + "'");

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Gouri Shankar9y ago
Hi,

For converting you can use as below:
"DateTime.ParseExact()" or "TryParseExact()" with a custom format string.\

Hope this solved your issue.

Thanks,
Gouri Shankar
0
yesubabu k9y ago
while inserting data from excel to gridview or database

ERROR

The string was not recognized as a valid DateTime. There is a unknown word starting at index 0.

above error raised
0