How Can I Insert Multiple Values To Database From Gridview on button click?

See more:

ASP.NET

C#3.5

SQL-Server-2008R2

protected void btnTest_Click(object sender, EventArgs e)
{

foreach (GridViewRow row in gvUserGroupDetails.Rows)
{


String access = "";
string add = "";


Label lblMenuID=(row.Cells[0].FindControl("lblMenuID") as Label);
Label lblMenuName=(row.Cells[0].FindControl("lblMenuName") as Label);
CheckBox chkAccess = (row.Cells[0].FindControl("cblAccess") as CheckBox);
CheckBox chkAdd = (row.Cells[0].FindControl("cblAdd") as CheckBox);
CheckBox chkEdit = (row.Cells[0].FindControl("cblEdit") as CheckBox);



if (chkAccess.Checked == true)
{
access = "Y";
}
else
{
access = "N";
}
if (chkAdd.Checked == true)
{
add = "Y";
}
else
{
add = "N";
}




con.exeUpdate("insert into test values(" + lblMenuID + ",'" + lblMenuName + "','" + access + "','" + add + "')");


}



}