public DataTable SelectAll(string query)
{
da = new SqlDataAdapter(query, ProductDAL.connect());
DataTable dt = new DataTable();
da.Fill(dt);
return(dt);
}
public bool DMLOpperation(string query)
{
cmd = new SqlCommand(query, ProductDAL.connect());
int x = cmd.ExecuteNonQuery();
if (x == 1)
{
return(true);
}
else
{
return(false);
}
}