how to save multiple records from datagridview having a datagridviewtextbox column and datagridviewCheckboxcolumn in database

Question

1.00/5 (1 vote)

See more:

I have two combobox on my window form, one is batch combobox when user will select a batch related students will be filled in datagridview,and other combo is for employee who will take attendance. and a datagridview , gridview has three columns one is Checkbox column and one is Text box column and third is showing students name(student column will be filled on basis of batch selection, i want at single button click to save all records in database, and also i fetched the students name from database and want to save their keys not their names, How it can be implemented,
please help,below is my code but it is not working

C#

da.ProcName = "AddStudentsAttendance";
foreach(Object items in dg.Rows)
{
    DataRow dr = items as DataRow;
    da.OpenDBConnection();
    da.CreateCommandObject();
    da.Parameters("@Date", txtDate.Text);
    da.Parameters("@keyEmployee", int.Parse(txtEmployee.SelectedValue.ToString()));
    da.Parameters("@AddmissionNo",dr["Admission_No"].ToString() );
    da.Parameters("@Present", dr["Present"].ToString());
    da.Parameters("@Reason", dr["Reason"].ToString());
    da.ExecuteNonQuery();

}

Posted 27-May-14 20:25pm

Abdullah Kundi

Updated 27-May-14 20:33pm

DamithSL

v4

Add a Solution

Comments

DamithSL 28-May-14 2:31am

Any exceptions?

Abdullah Kundi 28-May-14 2:36am

Object reference not set to an instance of an object.
the error is genarated at da.parameters("@AdmissionNO",..........) line

Naz_Firdouse 28-May-14 2:44am

Make sure there exists a column named "Admission_No" in dr. Debug and check whether 'items' contains Admission_No field.

Abdullah Kundi 28-May-14 2:48am

I have changed the column to Student,
problem is with foreach(object item in dg.rows)
dataRow dir = item as datarow;
here in dir null value ( if debugger is used)

Naz_Firdouse 28-May-14 2:55am

As Damith specified in the below answer, use DataGridViewRow instead of Object class

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

DamithSL · Answer 1 · 2014-05-27T20:49:00

Solution 1

iterate rows as below

C#

foreach (DataGridViewRow row in dg.Rows)
{
   var cellValue =row.Cells["ColumnName"].Value;
}

Posted 27-May-14 20:49pm

DamithSL

Comments

Abdullah Kundi 28-May-14 2:57am

thanks for reply but .Cells is not supported what to do?

DamithSL 28-May-14 3:00am

it is there,http://msdn.microsoft.com/en-us/library/system.windows.forms.datagridviewrow.cells(v=vs.110).aspx[^]
should work if dg is DataGridView

Abdullah Kundi 28-May-14 3:38am

Thanks a lot, it works