如何在Windows应用程序中使用内存变量在组合框的控制中显示数据 [英] How to display data in control of combobox by using memory variable in windows application
问题描述
在我的申请中，我有3种表格.在每种形式中，我都有两个按钮下一步"和后退"按钮.我曾经使用过的下一个按钮转到下一个表单，而后退按钮则用于转到上一个表单.在下一个按钮单击事件中，我将控制数据存储在内存变量中，并且还将数据存储在sql中，然后将其转换为下一个形式.当我转到第二种形式后，我单击了第二种形式的后退"按钮，它将转到上一种形式，但是数据没有显示在组合框中，而我选择的是来自数据库的组合框，而其余控件则显示数据.有什么方法可以将来自数据库的combox选定数据存储在内存变量中.下面我提到我的代码.在combobox中，我使用combobox的DisplayMember属性从数据库中检索和dsiplay数据.
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.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
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
{
}
}
推荐答案
如何绑定cmbFourthOrgLevel?
并且如果Data.fourthorglevel返回 值成员 ，则
它应该写成如下形式，
how do you bind cmbFourthOrgLevel?
and if Data.fourthorglevel returns value-member then
it should be written as below,
cmbFourthOrgLevel.SelectedValue = Data.fourthorglevel;
祝您编码愉快！
:)
Happy Coding!
:)
当Combobox禁用时，它将失去其选择的值.我正在与asp.净，因此在Web应用程序中也会发生这种情况.我们要做的是，当页面加载时将选定的值存储在隐藏的控件中，并在显示时再次分配
到组合框.
所以我不知道天气在Windows应用程序中没有任何隐藏的控件.如果不存在，请使用文本框之类的控件，然后尝试.......
我希望它能起作用.
Hi,
when Combobox getting disable it loose its selected value. i am working with asp. net so in web application also this thing happen. what we do, we store that selected value in hidden control when page gets load and at the time of display again assign
to the combobox.
So i dont know weather there any hidden control in windows application. if it is not there then take one control like textbox and try..........
I hope it will work.
这篇关于如何在Windows应用程序中使用内存变量在组合框的控制中显示数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
