首先在vs2005中引入using System.Data.SqlClient;命名空間
/// 查詢
/// </summary>
/// <returns></returns>
public DataTable Select()
{
SqlConnection conn = new SqlConnection(@"Data Source=.\SQLEXPRESS;Initial Catalog=Test;Integrated Security=True");//Initial Catalog後面跟妳數據庫的名字,如果妳的SqlServer服務器名稱後面不帶SQLEXPRESS,那麽Data Source=.
conn.Open();
string sql = "select * from users";
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
sda.Fill(dt);
conn.Close();
cmd.Dispose();
return dt;
}
方法寫好後,在form窗體中拖壹個comboBox,然後在Load方法中
private void Form1_Load(object sender, EventArgs e)
{
comboBox1.DataSource = Select();//綁定數據
comboBox1.DisplayMember="name";//下拉列表中顯示的是妳數據庫中name的值
comboBox1.ValueMember ="id";//這個壹般綁定的是id,增加刪除之用。這個屬性也可不設
}
這樣壹運行,comboBox中就會顯示數據了!