Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
4
Reply
iterating through rows in a girdview.
Peter Dzuya
Aug 15 2017 4:15 AM
209
Reply
Thank you so much for this forum.
I have a gridview which I have used to import data from Microsoft excel.Now I want to pick selected colums and save them into my database. I have used the following code.
foreach (DataGridViewRow dgvr in dataGridView1.Rows){
DataRow dr = ((DataRowView)dgvr.DataBoundItem).Row;
if (dr["BOXNO"].ToString() != null) {
var boxNumber = dr["BOXNO"].ToString();
var dateOfSale = dr["DATEOFSALE"].ToString();
var broker = dr["BROKER"].ToString();
var lotNumber = dr["LOTNO"].ToString();
var gden = dr["GARDENMARK"].ToString();
var invoiceNumber = dr["INVOICENO"].ToString();
}
}
It iterates all records well, but then I get the following exception "Object referencenot set to an instanceod an object".
Please assist.
Thanks
Peter Dzuya.
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
4
)
Next Recommended Forum
How to define height and width for sub-menu stripe
How to dropdowns & datepickers change border color in C#