如何使用win形式的存储过程选择列表框值 [英] how to select list box value using stored procedure in win form

问题描述

hi



我正在尝试使用存储过程检索列表框中的值。我是wform的列表框但它不起作用。我做错了什么。请你给出解决方案

hi

I am trying to retrieve value in listbox using stored procedure. i m wform's listbox but it is not working. what i am doing wrong. can u please give the solution

private void listWBox_SelectedIndexChanged(object sender, EventArgs e)
        {
             string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
             using (SqlConnection con = new SqlConnection(CS))
           

                try
                {
                    SqlDataAdapter da = new SqlDataAdapter();
                     DataTable dt = new DataTable();

                    con.Open();
                    SqlCommand sqlcmd = new SqlCommand("readListWBox", con);
                    sqlcmd.CommandType = CommandType.StoredProcedure;
                    da.SelectCommand = sqlcmd;
                    da.Fill(dt);
                    listJobBox.DataSource = dt;              
                    
                    
                }
                catch (Exception ex)                
                {

                    MessageBox.Show("exception raised");
                
                }

                finally
                {

                    con.Dispose();
                    con.Close();
                
                }

        }

推荐答案

你应该设置 listJobBox.DisplayMember 到您要显示的 DataTable 中列的名称。



例如：

您在数据表中有一个名为'FirstName'的列;

然后

You should set listJobBox.DisplayMember to the name of the column in the DataTable you want to display.

For example:
You have a column in the data table called 'FirstName';
Then

listJobBox.DisplayMember = "FirstName";

这篇关于如何使用win形式的存储过程选择列表框值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！