How to update selected checkbox row to database from gridvie

My code as follows

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindData();
}
}
protected void BindData()
{
String strConnString = ConfigurationManager.ConnectionStrings["ConnectionStrings"].ConnectionString;
SqlConnection con = new SqlConnection(strConnString);
SqlCommand cmd = new SqlCommand("select * from [transact].[transaction_item] where status = 'new'", con);
con.Open();
SqlDataAdapter da = new SqlDataAdapter();
DataSet ds = new DataSet();
da.SelectCommand = cmd;
da.Fill(ds);
grdRpt.DataSource = ds;
grdRpt.DataBind();
}
protected void grdRpt_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
grdRpt.PageIndex = e.NewPageIndex;
BindData();
}

when i run the above code output as follows

selectdata transactid transactitemtype transactorgin status

Checkbox 1 123 IVC New

Checkbox 2 245 IVC New

Checkbox 3 345 IVC New

Checkbox 4 645 IVC New

Checkbox 5 723 IVC New

Checkbox 6 445 IVC New

Checkbox 7 545 IVC New

Checkbox 8 923 IVC New

Checkbox 9 245 IVC New

Checkbox 10 845 IVC New

1 2

1 and 2 paging will be there in the gridview

in first page five records will displayed and in the second page another five records will displayed.

suppose in the first page i check two rows and in the second page i check two rows means that selected check box rows to update in the [transact].[transaction_item] in the table.

for that how to do using c#.

2 Replies

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

Manish Mishra8y ago
In gridview you should use--- OnRowCommand, and in checkbox you use--CommandName="update" CommandArgument="<%# ((GridViewRow) Container).RowIndex %>",

when you click on checkbox it select the id of your row and perform appropriate operation which you want.
0
Ravi Kiran Chanduri8y ago
Hello Narasiman,

Viewstate can help you here. on row selection, you can store the id in viewstate as comma separated values. Now, you use them in the final update.
0