将SQL Integer转换为combobox的c#字符串(Access数据库)

using System;
using System.Data;
using System.Data.OleDb;
using System.Windows.Forms;

namespace YourNamespace
{
    public partial class YourForm : Form
    {
        public YourForm()
        {
            InitializeComponent();
        }

        private void YourForm_Load(object sender, EventArgs e)
        {
            // 建立与Access数据库的连接
            string connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=YourDatabase.accdb";
            using (OleDbConnection connection = new OleDbConnection(connectionString))
            {
                // 执行查询语句，将结果填充到DataTable中
                string query = "SELECT YourIntegerField FROM YourTable";
                OleDbDataAdapter adapter = new OleDbDataAdapter(query, connection);
                DataTable dataTable = new DataTable();
                adapter.Fill(dataTable);

                // 创建List来存储combobox的字符串选项
                var comboBoxItems = new List<string>();

                // 遍历DataTable中的每一行，将SQL Integer转换为字符串并添加到List中
                foreach (DataRow row in dataTable.Rows)
                {
                    int intValue = Convert.ToInt32(row["YourIntegerField"]);
                    string stringValue = intValue.ToString();
                    comboBoxItems.Add(stringValue);
                }

                // 将List绑定到combobox的数据源
                yourComboBox.DataSource = comboBoxItems;
            }
        }
    }
}