protected void btnUpdate_Click(object sender, EventArgs e) { lblEMsg.Visible = false; string[] Pub; Profile pro = new Profile(); try { if (lstid.SelectedItem.Text == "") { lblEMsg.Text = "Please select Publisher ID"; lblEMsg.Visible = true; } else { Pub = new string[15]; Pub[0] = lstid.Text; Pub[1] = txtPName.Text; Pub[2] = txtPYear.Text; Pub[3] = txtPHouse.Text; Pub[4] = txtPEdition.Text; Pub[5] = txtAdd.Text; Pub[6] = txtPhone.Text; Pub[7] = txtFax.Text; Pub[8] = txtemail.Text; if (chkStatus.Checked == true) { Pub[9] = "A"; } else { Pub[9] = "D"; } bool status; status = pro.UpdatePublisher(Pub); if (status == false) { lblEMsg.Visible = true; lblEMsg.Text = "Publisher updation Failed"; } lblEMsg.Visible = true; lblEMsg.Text = "Publisher updated."; //Load all the Category First. string sql = "SELECT Publisher_ID FROM Publisher"; SqlDataReader sdr; sdr = pro.ReturnMDetails(sql); lstid.Items.Clear(); while (sdr.Read()) { lstid.Items.Add(sdr["Publisher_ID"].ToString().Trim()); } sdr.Close(); return; //txtCName.Text = ""; //txtcDesc.Text = ""; } } catch (Exception ex) { throw ex; } }