protected void Page_Load(object sender, EventArgs e) { if (!this.IsPostBack) { this.Method_1(); } } private void Method_1() { string connString = ConfigurationManager.ConnectionStrings["***"].ConnectionString; using (conn = new SqlConnection(connString)) { conn.Open(); using (SqlCommand comm = new SqlCommand("GetStoredProc_1", conn)) { using (SqlDataReader reader = comm.ExecuteReader()) { if (reader.Read()) { Something here is true if(Something here is true) { reader.Close(); LoadSchedule(); LoadTeamRecord(); } else { Response.Redirect("Some Page.aspx"); } } } } } } private void LoadSchedule() { string connString = ConfigurationManager.ConnectionStrings["***"].ConnectionString; using (SqlConnection conn = new SqlConnection(connString)) { conn.Open(); using (SqlCommand comm = new SqlCommand("GetStoredProc_2", conn)) { using (SqlDataReader reader = comm.ExecuteReader()) { myRepeater.DataSource = reader; myRepeater.DataBind(); ......
SqlConnection
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)