protected void DropTransferFrom_SelectedIndexChanged(object sender, EventArgs e) { if (DropTransferFrom.SelectedValue != null) { string CustomerID = Request.QueryString["CustomerID"]; DropTransferTo.Items.Clear(); SqlConnection cn2 = new SqlConnection(strcn); cn2.Open(); SqlCommand cmd2 = new SqlCommand("usp_GetCustomerAccountList", cn2); cmd2.CommandType = CommandType.StoredProcedure; cmd2.Parameters.Add("@CustomerID", CustomerID); SqlDataReader reader2 = cmd2.ExecuteReader(); if (reader2.HasRows) { DropTransferTo.DataSource = reader2; DropTransferTo.DataTextField = "AccountNo"; DropTransferTo.DataValueField = "AccountNo"; DropTransferTo.DataBind(); } cn2.Close(); int i = DropTransferFrom.Items.Count; for (int j = 0; j < i; j++) { if (DropTransferFrom.Items[j].Selected == true) { DropTransferTo.Items.Remove(DropTransferFrom.Items[j].ToString()); i--; } } } }
//String strcn = @"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\Mittal\Desktop\OnlineBankingWebApplication\OnlineBankingWebApplication\App_Data\OnlineBanking.mdf;Integrated Security=True;User Instance=True"; protected void Page_Load(object sender, EventArgs e) { string CustomerID = Request.QueryString["CustomerID"]; if (CustomerID != null) { if (!IsPostBack) { SqlConnection cn1 = new SqlConnection(strcn); cn1.Open(); SqlCommand cmd1 = new SqlCommand("usp_GetCustomerAccountList", cn1); cmd1.CommandType = CommandType.StoredProcedure; cmd1.Parameters.Add("@CustomerID", CustomerID); SqlDataReader reader1 = cmd1.ExecuteReader(); if (reader1.HasRows) { DropTransferFrom.DataSource = reader1; DropTransferFrom.DataTextField = "AccountNo"; DropTransferFrom.DataValueField = "AccountNo"; DropTransferFrom.DataBind(); } cn1.Close(); SqlConnection cn2 = new SqlConnection(strcn); cn2.Open(); SqlCommand cmd2 = new SqlCommand("usp_GetCustomerAccountList", cn2); cmd2.CommandType = CommandType.StoredProcedure; cmd2.Parameters.Add("@CustomerID", CustomerID); SqlDataReader reader2 = cmd2.ExecuteReader(); if (reader2.HasRows) { DropTransferTo.DataSource = reader2; DropTransferTo.DataTextField = "AccountNo"; DropTransferTo.DataValueField = "AccountNo"; DropTransferTo.DataBind(); } cn2.Close(); } if (DropTransferFrom.SelectedValue != null) { int i = DropTransferFrom.Items.Count; for (int j = 0; j < i; j++) { if (DropTransferFrom.Items[j].Selected == true) { DropTransferTo.Items.Remove(DropTransferFrom.Items[j].ToString()); i--; } } } } else { Response.Redirect("CustomerLogin.aspx"); } }