In my application i have 3 forms . In each form i have two button Next and Back button. The Next button i used to go to next form and back button is used to go to previous form. In next button click event i store data of control in memory varibale and also store data in sql and after that it goes to next form. when i goes to second form and after that i clicked on back button of second form it goes to previous form but data is not display in combobox which i selcted which is come from database.but rest of the control display data. Is there any way to store combox selected data which is come from database in memory varibale. below i mention my code. In combobox i retrive and dsiplay data from database using DisplayMember property of combobox .
private void btnnext_Click(object sender, EventArgs e)
{
try
{
using (SqlConnection conn = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]))
{
using (SqlCommand cmd = new SqlCommand())
{
conn.Open();
cmd.Connection = conn;
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Transtype", "SaveEmployeeSelfDetail");
cmd.Parameters.AddWithValue("@Employee_Code", employeecode);
cmd.Parameters.AddWithValue("@Salutation", salutaion);
cmd.Parameters.AddWithValue("@FirstName", firstname);
cmd.Parameters.AddWithValue("@MiddleName", middlename);
cmd.Parameters.AddWithValue("@LastName", lastname);
cmd.Parameters.AddWithValue("@Gender", gender);
cmd.Parameters.AddWithValue("@DateOfBirth", dateofbirth);
cmd.Parameters.AddWithValue("@MaritalStatus", martialstatus);
cmd.Parameters.AddWithValue("@FatherName", fathername);
cmd.Parameters.AddWithValue("@DateOfJoin", dateofjoin);
cmd.Parameters.AddWithValue("@EmpOrg1", firstorglevel);
cmd.Parameters.AddWithValue("@EmpOrg2", secondorglevel);
cmd.Parameters.AddWithValue("@EmpOrg3", thiredorglevel);
cmd.Parameters.AddWithValue("@EmpOrg4", fourthorglevel);
cmd.Parameters.AddWithValue("@EmpOrg5", fifthorglevel);
cmd.Parameters.AddWithValue("@EmpOrg6", sixorgl);
cmd.Parameters.AddWithValue("@EmpOrg7", sevenorglevel);
cmd.Parameters.AddWithValue("@EmpOrg8", eightorglevel);
cmd.CommandText = "Hiring_CreateNewEmployee";
SqlDataAdapter dAdapter = new SqlDataAdapter();
dAdapter.SelectCommand = cmd;
cmd.ExecuteNonQuery();
conn.Close();
}
}
}
catch (Exception ex)
{
lblerror.Text = ex.Message;
}
Data.salutaion = salutaion;
Data.fathername = txtfathername.Text;
Data.empid = employeecode;
Data.firstorglevel = firstorglevel;
Data.secondorglevel = secondorglevel;
Data.thiredorglevel = thiredorglevel;
Data.fourthorglevel = fourthorglevel;
Data.fifthorglevel = fifthorglevel;
Data.sixorgl = sixorgl;
Data.sevenorglevel = sevenorglevel;
Data.eightorglevel = eightorglevel;
Data.firstname = firstname;
Data.lastname = lastname;
Data.middlename = middlename;
Data.martialstatus = martialstatus;
Data.gender = gender;
Data.dateofbirth = dateofbirth;
Data.dateofjoining = dateofjoin;
Data.dd = datetimejoin.Value;
}
// calling function on click on back button of 2nd form which display data in control
public void DisplyEmployeeSelfDetails()
{
try
{
txtemployeecode.Text = Data.empid;
cmbFirstOrgLevel.SelectedItem = Data.firstorglevel;
cmbSecondOrgLevel.SelectedItem = Data.secondorglevel;
cmbThiredOrgLevel.SelectedItem = Data.thiredorglevel;
cmbFourthOrgLevel.SelectedItem = Data.fourthorglevel;
cmbFifthOrgLevel.SelectedItem = Data.fifthorglevel;
cmbsixorglevels.SelectedItem = Data.sixorgl;
cmbsevenorglevel.SelectedItem = Data.sevenorglevel;
cmbeightorglevel.SelectedItem = Data.eightorglevel;
cmbsalutation.SelectedItem = Data.salutaion;
txtfathername.Text = Data.fathername;
txtfirstname.Text = Data.firstname;
txtlastname.Text = Data.lastname;
txtmiddlename.Text = Data.middlename;
combomaritalstatus.SelectedItem = Data.martialstatus;
combogender.SelectedItem = Data.gender;
datetimejoin.Value = Convert.ToDateTime(Data.dateofjoining);
datetimebirth.Value = Convert.ToDateTime(Data.dateofbirth);
}
catch
{
}
}