public void PopulateGrid(GridView grdView, string sqlQuery, Page form)
{
try
{
adp = new SqlDataAdapter(sqlQuery, conn);
tbl = new DataTable();
adp.Fill(tbl);
grdView.DataSource = tbl;
grdView.DataBind();
}
catch (Exception ex)
{
MsgBox("Populate GridView Error: " + ex.Message, form);
}
}
public void PopulateGrid(DataGrid dtGrd, string sqlQuery, Page form)
{
try
{
adp = new SqlDataAdapter(sqlQuery, conn);
tbl = new DataTable();
adp.Fill(tbl);
dtGrd.DataSource = tbl;
dtGrd.DataBind();
}
catch (Exception ex)
{
MsgBox("Populate DataGrid Error: " + ex.Message, form);
}
}
public void PopulateGrid(DataList dtLst, string sqlQuery, Page form)
{
try
{
adp = new SqlDataAdapter(sqlQuery, conn);
tbl = new DataTable();
adp.Fill(tbl);
dtLst.DataSource = tbl;
dtLst.DataBind();
}
catch (Exception ex)
{
MsgBox("Populate DataList Error: " + ex.Message, form);
}
}