need help to modify the exixting code with the current
in ! is postback i have currently the foloowing
sQuery = "IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES ";
sQuery = sQuery + " WHERE TABLE_NAME='tempstd') DROP TABLE tempstd";
executeit
sQuery = "Select * into tempstd from Employee";
executeit
then i have a function for binding grid in whic i have many critreias
currently teh function is
bindgrid()
{
"Select * from tempstd
execute as
SqlDataAdapter da = new SqlDataAdapter( sQuery, conn);
DataTable dt = new DataTable();
da.Fill(dt);
grid.DataSource = dt;
gris.DataBind();
}
how do i adjust the exixting code with new method