سلام
این کد رو ببین شاید کمکت کنه:
str_conn =
ConfigurationManager.AppSettings.Get(0);
sql_conn.ConnectionString = str_conn;
sql_adp.SelectCommand = newSqlCommand();
sql_adp.SelectCommand.Connection = sql_conn;
sql_comm.Connection = sql_conn;
sql_adp.SelectCommand.CommandType = CommandType.StoredProcedure;
sql_adp.SelectCommand.CommandText = "select_all_customer";
sql_conn.Open();
sql_adp.Fill(ds, "customer_register");
sql_conn.Close();
grd_user.DataSource = ds;
grd_user.DataMember = "customer_register";
grd_user.DataBind();
if (ds.Tables[0].Rows.Count == 0)
{
lbl_er.Text = ".هیچ اطلاعاتی یافت نشد";
}
ds.Clear();