//SELECT
public void UpdateGridview()
{
SqlConnection conn = new SqlConnection(@"data source = .\sqlexpress; integrated security = true; database = Patient_dentist;");
SqlCommand cmd = null;
//data reader
SqlDataReader rdr = null;
try
{
conn.Open();
cmd = conn.CreateCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "MySelectAllRes";
SqlParameter in1 = cmd.Parameters.Add("@ID_patient", SqlDbType.Int);
in1.Direction = ParameterDirection.Input;
in1.Value = Convert.ToInt32(Session["id"].ToString());
//ExecuteReader -> access results
rdr = cmd.ExecuteReader();
GridViewUpdateRes.DataSource = rdr;
GridViewUpdateRes.DataBind(); //withought databind wont display anything
}
catch (Exception ex)
{
LabelMessageCRR.Text = ex.Message + ex.StackTrace;
}
finally
{
conn.Close();
}
}
public void UpdateGridview()
{
SqlConnection conn = new SqlConnection(@"data source = .\sqlexpress; integrated security = true; database = Patient_dentist;");
SqlCommand cmd = null;
SqlDataReader rdr = null;
try
{
conn.Open();
cmd = conn.CreateCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "MySelectRes";
SqlParameter in1 = cmd.Parameters.Add("@ID_patient", SqlDbType.Int);
in1.Direction = ParameterDirection.Input;
in1.Value = Convert.ToInt32(Session["id"].ToString());
rdr = cmd.ExecuteReader();
GridViewUpdateRes.DataSource = rdr;
GridViewUpdateRes.DataBind();
rdr.Close();
rdr = cmd.ExecuteReader();
DropDownListRes.DataSource = rdr;
DropDownListRes.DataTextField = "ID_res";
DropDownListRes.DataValueField = "ID_res";
DropDownListRes.DataBind();
DropDownListRes.Items.Insert(0, "Select a reservation ID");
}
catch (Exception ex)
{
LabelMessageCRR.Text = ex.Message;
}
finally
{
conn.Close();
}
}