how to save the datagraidview selected rows in database

how to save the datagraidview selecter rows save in database if some rows checked in the grid

they insert the only one record in database pleas help me i am beginner

private void button1_Click(object sender, EventArgs e)

{

bool ReturnStatus = true;

String ReturnMessage = "";

//int ClassId =1;

try

{

//call function to save the data in database...

for (int i = 0; i <= dataGridView1.Rows.Count - 1; i++)

{

if ((bool)dataGridView1.Rows[i].Cells["chk"].Value == true)

{

List PRM = new List();

PRM.Add(new SqlParameter() { ParameterName = "@ClassName", Value = tbx_classname.Text });

PRM.Add(new SqlParameter() { ParameterName = "@Subject_Id", Value =dataGridView1.Rows[i].Cells["id"]});

PRM.Add(new SqlParameter() { ParameterName = "@TotalMarks", Value = dataGridView1.Rows[i].Cells["TotalMarks"]});

PRM.Add(new SqlParameter() { ParameterName = "@PassingMarks", Value = dataGridView1.Rows[i].Cells["PassingMarks"]});

rp.dbManage("[School].[CreateClass]", PRM, out ReturnStatus,out ReturnMessage);

MessageBox.Show(ReturnMessage.ToString());

}

private void btnInsert_Click(object sender, EventArgs e)
{
int inserted = 0;
foreach (DataGridViewRow row in dataGridView1.Rows)
{
bool isSelected = Convert.ToBoolean(row.Cells["checkBoxColumn"].Value);
if (isSelected)
{
string constring = @"Data Source=.\SQL2014;Initial Catalog=AjaxSamples;Integrated Security=true";
using (SqlConnection con = new SqlConnection(constring))
{
using (SqlCommand cmd = new SqlCommand("INSERT INTO Customers VALUES(@CustomerId, @Name, @Country)", con))
{
cmd.Parameters.AddWithValue("@CustomerId",row.Cells["Id"].Value);
cmd.Parameters.AddWithValue("@Name", row.Cells["Name"].Value);
cmd.Parameters.AddWithValue("@Country",row.Cells["Country"].Val);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
inserted++;
}
}
if (inserted > 0)
{
MessageBox.Show(string.Format("{0} records inserted.", inserted), "Message");
}
}

1 Reply

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