如何在按钮单击时从Gridview将多个值插入数据库？ [英] How Can I Insert Multiple Values To Database From Gridview on button click?

问题描述

protected void btnTest_Click（object sender，EventArgs e）

{



foreach（gvUserGroupDetails.Rows中的GridViewRow行）

{





String access =;

string add =;





标签lblMenuID =（row.Cells [0] .FindControl（lblMenuID）为标签）;

标签lblMenuName =（row.Cells [0] .FindControl（lblMenuName）作为标签）;

CheckBox chkAccess =（row.Cells [0] .FindControl（cblAccess）as CheckBox）;

CheckBox chkAdd =（row.Cells [0] .FindControl（cblAdd）作为CheckBox）;

CheckBox chkEdit =（row.Cells [0] .FindControl（cblEdit）作为CheckBox）;







if（chkAccess.Checked ==是的）

{

access =Y;

}

else

{

access = N;

}

if（chkAdd.Checked == true）

{

add = Y;

}

其他

{

add =N;

$









con.exe更新（插入到测试值（+ lblMenuID +，+ lblMenuName +'，'+ access +'，'+ add +'））;





}







}

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 + "')");


}



}

推荐答案

请在C＃+ ExecuteNonQuery上谷歌，你会发现必要的信息。



另外，如需样品，请参阅以下链接。



http://www.java2s.com/Code/CSharp/Database-ADO.net/usetheExecuteNonQuerymethodtorunINSERTUPDATEandDELETEstatements.htm [ ^ ]



谢谢

Hi,


Please google on C# + ExecuteNonQuery and you will find the necessary information.

Also for a sample please refer below link.

http://www.java2s.com/Code/CSharp/Database-ADO.net/usetheExecuteNonQuerymethodtorunINSERTUPDATEandDELETEstatements.htm[^]

Thanks

试试使用-使用SqlBulkCopy到嵌件批量数据从-的GridView到数据库的功能于ASPNet.aspx [ ^ ]

这篇关于如何在按钮单击时从Gridview将多个值插入数据库？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！