每次使用不同的参数调用方法时,我需要将查询结果添加到datatable
中。但现在每次都会覆盖datatable
的内容,而不是追加。
是否有可能进行追加?请帮帮我...
Protected void chkrow_CheckedChanged(object sender, EventArgs e)
{
DataTable dtble = new DataTable();
CheckBox chkrow = (CheckBox)sender;
gridViewRow gvrow = chkrow.Parent.Parent;
GridView gvemp = (GridView) grdemp.Rows[gvrow.RowIndex].Cells[2].FindControl("gvemp");
string emp = grdemp.DataKeys[gvrow.RowIndex].Values[2].ToString();
if(gvemp.Checked == true)
{
string sqls = "select * from emptable where empid= ' " + emp.ToString() + "' " ;
OracleCommand cmd = new OracleCommand(sqls, cn) ;
OracleDataAdapter da = new OracleDataAdapter(cmd) ;
da.Fill(dtble);
//here I need to append result to dtble rather than overwriting when each checkbox is checked
}
}