protected void DropDownListSchools_SelectedIndexChanged(object sender, EventArgs e) { SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["PasswordConnectionString"].ConnectionString); con.Open(); lblINST_ID.Text = DropDownListSchools.SelectedValue; } protected void DropDownListCFY1_SelectedIndexChanged(object sender, EventArgs e) { SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["PasswordConnectionString"].ConnectionString); con.Open(); SqlCommand scmd = new SqlCommand("Select TOTASSETS, TOTLIABILITY from TableFIN where INST_ID = " + DropDownListCFY1.SelectedValue.ToString(), con); SqlDataReader dr = scmd.ExecuteReader(); if (dr.Read()) { TextBoxTA1.Text = dr["TOTASSETS"].ToString(); TextBoxTL1.Text = dr["TOTLIABILITY"].ToString(); } dr.Close(); con.Close(); } protected void DropDownListCFY2_SelectedIndexChanged(object sender, EventArgs e) { SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["PasswordConnectionString"].ConnectionString); con.Open(); SqlCommand scmd = new SqlCommand("Select TOTASSETS, TOTLIABILITY from TableFIN where INST_ID = " + DropDownListCFY2.SelectedValue.ToString(), con); SqlDataReader dr = scmd.ExecuteReader(); if (dr.Read()) { TextBoxTA2.Text = dr["TOTASSETS"].ToString(); TextBoxTL2.Text = dr["TOTLIABILITY"].ToString(); } dr.Close(); con.Close();
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)