如何使用复选框保存datagridview记录 [英] how to save datagridview record using checkbox
问题描述
请注意它是Windows应用程序。
数据网格视图中的
如下;
选择姓名Orderno OrderDate
复选框Ram 1 2/27/2013
复选框Sam 2 2/25/2013
复选框Vimal 3 2/28/2013
复选框suresh 4 2/26/2013
从上面的记录我选择datagridview中的第一个和最后一个记录使用复选框并想要保存在数据库中。
输出我想保存在数据库中,如下所示;
名称Orderno OrderDate
Ram 1 2/27/2013
suresh 4 2/26/2013
获得以上输出如何使用c sharp在保存按钮中编写代码。
注意它是windows应用程序。
private void Btn_Save_Clic k(对象发送者,EventArgs e)
{
//在那个我要写的代码中,以便第一个和最后一个记录保存在数据库中
}
嗨..
看看在下面的示例中: -
protected void btnSave_Click( object sender,EventArgs e)
{
尝试
{
foreach (GridViewRow gr in gvAFBatProc.Rows)
{
sbQry.Clear();
sbQry.Append( INSERT INTO + dbName + tbl< pre>& quot;
sbQry.Append((BID,BATCH_NO,LOAD_NO,SECTION_NO,LOT_NO) VALUES( );
sbQry.Append(strBatchNo +, );
sbQry.Append(strBatchNo.Remove(0,7).Trim()+,< span class =code-string> );
sbQry.Append( '' +((Label)gr.FindControl(lblLoadNo))。Text +', );
sbQry.Append( ' +((Label)gr.FindControl(lblSectionNo)) .Text +', );
sbQry.Append( ' +((Label)gr.FindControl(lblLotNo ))。文本+' );
sbQry.Append() );
OraObj.ExecuteQry(sbQry.ToString());
}
}
catch(exception ex)
{
}
}
< pre lang =c#>
问候
Willington
hi,
你试试
< pre lang =cs> for ( int j = 0 ; j < 此 .datagridview1.RowCount; j ++)
{
if (Convert.ToBoolean( this .datagridview1 [ 0 ,j] .Value)== true )
{
// 保存值
}
}
试试这个
foreach (GridViewRow gr in datagridview.Rows)
{
CheckBox chkbox = datagridview.FindControl( NameOfCheckbox) as CheckBox; // 找到复选框
if (chkgvOverDue.Checked) // 如果选中为真
{
// 在此处保存值
}
}
note it is windows application.
in datagridview has follows;
Select Name Orderno OrderDate
Checkbox Ram 1 2/27/2013
Checkbox Sam 2 2/25/2013
Checkbox Vimal 3 2/28/2013
Checkbox suresh 4 2/26/2013
From the above record i select the first and last record in the datagridview using checkbox and want to save in the database.
Output i want to save in the Database as follows;
Name Orderno OrderDate
Ram 1 2/27/2013
suresh 4 2/26/2013
for the getting above output how to write the code in the save button using c sharp.
note it is windows application.
private void Btn_Save_Click(object sender, EventArgs e)
{
//in that what code i want to written so that the first and last record save in the Database
}
Hi..
Look into the below example:-
protected void btnSave_Click(object sender, EventArgs e) { try { foreach (GridViewRow gr in gvAFBatProc.Rows) { sbQry.Clear(); sbQry.Append("INSERT INTO " + dbName + "tbl<pre>" sbQry.Append("(BID, BATCH_NO, LOAD_NO, SECTION_NO, LOT_NO) VALUES("); sbQry.Append(strBatchNo + ", "); sbQry.Append(strBatchNo.Remove(0, 7).Trim() + ", "); sbQry.Append("'" + ((Label)gr.FindControl("lblLoadNo")).Text + "', "); sbQry.Append("'" + ((Label)gr.FindControl("lblSectionNo")).Text + "', "); sbQry.Append("'" + ((Label)gr.FindControl("lblLotNo")).Text + "' "); sbQry.Append(")"); OraObj.ExecuteQry(sbQry.ToString()); } } catch (Exception ex) { } }
<pre lang="c#">
Regards
Willington
hi,
you try
for (int j = 0; j < this.datagridview1.RowCount; j++) { if (Convert.ToBoolean(this.datagridview1[0, j].Value) == true) { //save the values } }
try this
foreach (GridViewRow gr in datagridview.Rows) { CheckBox chkbox= datagridview.FindControl("NameOfCheckbox") as CheckBox; // find the check box if (chkgvOverDue.Checked) // if Checked True { //Save the Values Here } }
这篇关于如何使用复选框保存datagridview记录的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!