Tech
Forums
Jobs
Books
Events
Live
Interviews
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
2
Reply
inserting excel rows to database through gridview
yesubabu k
Nov 25 2016 5:39 AM
273
Reply
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() + "'");
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
2
)
Next Recommended Forum
Install and Uninstall Window service in windows Setup file
add radio button column in gridview