string str = "Select * from DBCUSTOMERMASTER "; DataTable dt = clstrans.getDataTable(str); grdTRANSANCTION.DataSource = dt; grdTRANSANCTION.DataBind(); for (int i = 0; i <grdtransanction.rows.count;> { string str2 = "select STATEMENTMENTDELIVERD from TBLTRANSACTIONMASTER where CUSTOMERID='" + grdTRANSANCTION.Rows[i].Cells[0].Text+ "' and MONTH='" + DdlMonth.SelectedItem.Text + "' and YEAR ='" + DDLYEAR.SelectedItem.Text + "'"; DataTable dt2 = clstrans.getDataTable(str2); CheckBox chk = (CheckBox)grdTRANSANCTION.Rows[i].FindControl("CHKPAYMENT"); string str1 = dt2.Rows[i]["STATEMENTMENTDELIVERD"].ToString(); if (str1 == "yes") { chk.Checked = true; } else { chk.Checked = false; } } } catch (Exception ex) { lblmessage.Text = ex.Message; }
if(dt.Rows.Count>0) { //Do youe Stuff }
DBCUSTOMERMASTER
string str = "Select * from DBCUSTOMERMASTER "; DataTable dt = clstrans.getDataTable(str); grdTRANSANCTION.DataSource = dt; grdTRANSANCTION.DataBind(); if(dt.rows.count>0) { for (int i = 0; i<grdtransanction.rows.count;i++)> { string str2 = "select STATEMENTMENTDELIVERD from TBLTRANSACTIONMASTER where CUSTOMERID='" + grdTRANSANCTION.Rows[i].Cells[0].Text+ "' and MONTH='" + DdlMonth.SelectedItem.Text + "' and YEAR ='" + DDLYEAR.SelectedItem.Text + "'"; DataTable dt2 = clstrans.getDataTable(str2); CheckBox chk = (CheckBox)grdTRANSANCTION.Rows[i].FindControl("CHKPAYMENT"); string str1 = dt2.Rows[i]["STATEMENTMENTDELIVERD"].ToString(); if (str1 == "yes") { chk.Checked = true; } else { chk.Checked = false; } } } } catch (Exception ex) { lblmessage.Text = ex.Message; }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)