inserting excel rows to database through gridview

Question

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() + ');

Gouri Shankar · Answer

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

yesubabu k · Answer

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