110,534
社区成员
发帖
与我相关
我的任务
分享
string sql = "Select D_ID, "+dateTimePicker3.Value.ToShortDateString() + " " + D_Title as title from yourtable";
OleDbDataAdapter Adapter = new OleDbDataAdapter();
DataTable myTable = new DataTable();
using (OleDbConnection connetion = new OleDbConnection(connectionString))//connectionString数据库存连接字串
{
Adapter.SelectCommand = new OleDbCommand(sql, connetion);
Adapter.Fill(myTable);
}
ListBox1.DataSource = myTable ; //这个表示给控件指定的数据源
ListBox1.DisplayMember = "title";//这个表示控制中显示的值
listBox1.ValueMember="D_ID";