Comments by Sreeraam_d (Top 5 by date)

Hi Humayun,

Thank you very much for the support you are given for me!
I hope it will work for me well!
Thanks&Regards
Sreeram_d

Hi Ryanb,

Please give me brief solution to this problem!

Regards
Sreeram

Hi Deenu,

I solved this problem here i put wrong code now the following code
string Gender = RadioButtonList1.SelectedItem.Text;
string Preference = CheckBoxList1.SelectedItem.Text;

is working for me. Thank you very much for the support.

Even though it is not updating, should i write any code for update on page load?

please correct the following page load code.

protected void Page_Load(object sender, EventArgs e)
{

if (!Page.IsPostBack)
{
DropDownList1.Items.Add("Manager");
DropDownList1.Items.Add("Assistant Manager");
DropDownList1.Items.Add("Sales Rep");

DropDownList2.Items.Add("Accounts");
DropDownList2.Items.Add("Sales");
}

string EmpNo = string.Empty;




if (!string.IsNullOrEmpty(Request.QueryString["EmpNo"]))
////if (Request.QueryString["EmpNo"]!= null)
{
EmpNo = Request.QueryString["EmpNo"].ToString();

// TextBox2.Text = "";
// DropDownList1.SelectedItem.Text = "";
// DropDownList2.SelectedItem.Text = "";
// TextBox3.Text = "";


SqlConnection con = new SqlConnection("Server=TCT-SW24;uid=sa;password=**********; database=sreeramdasari;");
SqlCommand cmd = new SqlCommand("select* from EmployeeDetails where EmpNo='" + EmpNo + "'", con);


//SqlCommand cmd = new SqlCommand("MyProcedure1", con);
//cmd.CommandType = CommandType.StoredProcedure;
con.Open();
cmd.Parameters.AddWithValue("@EmpNo", EmpNo);
SqlDataReader sdr = cmd.ExecuteReader();

if (sdr.Read())
{
TextBox1.Text = EmpNo;
TextBox2.Text = sdr[1].ToString();
DropDownList1.SelectedValue = sdr[2].ToString().Trim();
DropDownList2.SelectedValue = sdr[3].ToString().Trim();
TextBox3.Text = sdr[4].ToString();

}

TextBox1.Enabled = false;
Button1.Enabled = false;
Button2.Enabled = true;
Button3.Enabled = true;
Button4.Enabled = true;
con.Close();




}