如何填充SQL值动态列表框 [英] How to populate listbox dynamically with SQL values

问题描述

我是一个C＃初学者。我所试图做的是从一个SQL数据库中的列中提取数据，并将其写入到一个列表框。基本上，我想在列表框中动态显示在我的表的PART_NUM列中的数据。

I am a C# beginner. What I am trying to do is pull data from a column in a SQL database and write it to a listbox. Basically, I want the data in the part_num column of my table to be displayed dynamically in the listbox.

我所看到的：

this.listParts.Items.AddRange(new object[] {"Part1", "Part2"});

不过，我将如何去有关从SQL动态生成的值替换第1部分和第二部分？

But how would I go about replacing "Part1" and "Part2" with dynamically generated values from SQL?

public mainForm()
{
    InitializeComponent();
    SqlConnection conn = new SqlConnection(
        "Data Source=DBELL;Initial Catalog=part_table;Integrated Security=True");
    conn.Open();
    DataSet ds = new DataSet();
    SqlDataAdapter adapter = new SqlDataAdapter(
        "SELECT part_num from customParts", conn);
         adapter.Fill(ds);
    foreach (DataRow row in ds.Tables[0].Rows)
    {
        for (int i = 0; i < ds.Tables[0].Columns.Count; i++)

        this.listParts.Items.AddRange(new object[] {"Part1", "Part2"});
    }
}

任何帮助AP preciated！

Any help is appreciated!

推荐答案

为什么不使用数据表为数据源

public mainForm()
        {
            InitializeComponent();
            SqlConnection conn = new SqlConnection("Data Source=DBELL;Initial Catalog=part_table;Integrated Security=True");
            conn.Open();
            DataSet ds = new DataSet();
            SqlDataAdapter adapter = new SqlDataAdapter(
            "SELECT part_num from customParts", conn);
            adapter.Fill(ds);
            this.listParts.DataSource = ds.Tables[0]; 
            this.listParts.DisplayMember = "part_num"; 
        }

您应该数据集甚至更好，但读了的EntityFramework 和数据绑定。

You should read up on DataSets or even better yet EntityFramework and data-binding.

这篇关于如何填充SQL值动态列表框的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！