public void ShowMyData() { try { conn.Open(); cmd = new SqlCommand(sqlsel, conn); rdr = cmd.ExecuteReader(); RepeaterTreatments.DataSource = rdr; RepeaterTreatments.DataBind(); } catch (Exception ex) { LabelMessage.Text = ex.Message; } finally { conn.Close(); } }
protected void Page_Load(object sender, EventArgs e) { RepeaterTreatments.DataBind(); sqlsel = "Myselectalltreatments"; ShowMyData(); }