Click here to Skip to main content
15,867,453 members

How to display data in control of combobox by using memory variable in windows application

Manohar Khillare asked:

Open original thread
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 .

C#
 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.Parameters.AddWithValue("@ToDate", Convert.ToDateTime (dateTimePicker2.Text.Trim()));
                        cmd.CommandText = "Hiring_CreateNewEmployee";

                        SqlDataAdapter dAdapter = new SqlDataAdapter();
                        dAdapter.SelectCommand = cmd;
                        cmd.ExecuteNonQuery();
                        conn.Close();
                                            
                    }
                }

               // MessageBox.Show("Record Saved Successfully", "Self Details", MessageBoxButtons.OK, MessageBoxIcon.Information);



            }
            catch (Exception ex)
            {

                lblerror.Text = ex.Message;
            }


// store data in memory variable
            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.singleemployeearea = sixthorglevel;
            //Data.singleemployeearea = comboBox1.SelectedItem.ToString();
            Data.firstname = firstname;
            Data.lastname = lastname;
            Data.middlename = middlename;
           // Data.designation = sevenorglevel;
            Data.martialstatus = martialstatus;
            Data.gender = gender;
            Data.dateofbirth = dateofbirth;
            Data.dateofjoining = dateofjoin;
            //Data.employeetype = eightorglevel;
            Data.dd = datetimejoin.Value;
        }


// calling function on click on back button of 2nd form which display data in control
C#
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;
               //comboBox1.SelectedItem = Data.singleemployeearea;
               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
           {

           }
       }
Tags: C#, .NET (.NET 3.5)

Plain Text
ASM
ASP
ASP.NET
BASIC
BAT
C#
C++
COBOL
CoffeeScript
CSS
Dart
dbase
F#
FORTRAN
HTML
Java
Javascript
Kotlin
Lua
MIDL
MSIL
ObjectiveC
Pascal
PERL
PHP
PowerShell
Python
Razor
Ruby
Scala
Shell
SLN
SQL
Swift
T4
Terminal
TypeScript
VB
VBScript
XML
YAML

Preview



When answering a question please:
  1. Read the question carefully.
  2. Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
  3. If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
  4. Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.
Let's work to help developers, not make them feel stupid.
Please note that all posts will be submitted under the http://www.codeproject.com/info/cpol10.aspx.



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900