王思源

 

C# WinForm ListBox 绑定数据库代码

网上有篇文章《C# WinForm ListBox绑定数据库》但题目中是 ListBox 代码却是ListView。

这是我的代码,其中monFile是表名,process是列名,在VS 2008 中运行正常

 

 

private void Form1_Load(object sender, EventArgs e)
{
string sqlString = "SELECT DISTINCT process FROM monFile";
DataSet ds
= GetData(sqlString);

foreach (DataRow row in ds.Tables[0].Rows)
{
listBox1.Items.Add(row[
"process"].ToString());
}
}

DataSet GetData(String queryString)
{
using (SqlConnection conn = new SqlConnection("Data Source=SIYUAN\\SQLEXPRESS; Initial Catalog=monitor; User ID=siyuan; Pwd=123456"))
{
DataSet ds
= new DataSet();
try
{
// Connect to the database and run the query.
conn.Open();
SqlDataAdapter adapter
= new SqlDataAdapter(queryString, conn);
// Fill the DataSet.
adapter.Fill(ds);
}
catch (Exception ex)
{
// The connection failed. Display an error message.
label1.Text = "Unable to connect to the database.";
}
return ds;
}

}

 

posted on 2010-08-18 09:47  王思源  阅读(2601)  评论(0编辑  收藏  举报

导航