//sqlconnection连接字符串
@"Data Source= .\SQLEXPRESS;AttachDBFilename=C:\..\*.MDF;Integrated
Security=True;User Instance=True"))
//sqlconnection连接的基本步骤
using System.Data.SqlClient;
Dataset dataset = new DataSet();
string conStr=@"Data Source= .\SQLEXPRESS;AttachDBFilename=C:\SQL Server 2000 Sample Databases\NORTHWND.MDF;Integrated Security=True;User Instance=True";
using (SqlConnection conn = new SqlConnection(conStr))
{
conn.Open();
SqlDataAdapter adapter = new SqlDataAdapter(conn.CreateCommand());
adapter.SelectCommand.CommandText = "select * from customers";
adapter.Fill(dataset);
foreach (DataRow row in dataset.Tables[0].Rows)
{
string item=row["ContactTitle"]+","+row["ContactName"];
listBox1.Items.Add(item);
}
}