C#中利用ADO.NET连接和查询SQL数据库

using System.Data;
using System.Data.SqlClient;
...
SqlConnection sqlCon = new SqlConnection("Data Source=(local);Initial Catalog=pubs;User ID=sa;Password='' ");//Data Source为服务器;Initial Catalog为数据库;
sqlCon.Open();
sqlstr = "select id from tablename";
SqlDataAdapter sqlda = new SqlDataAdapter(sqlstr,sqlCon);
SqlCommandBuilder sqlCmdb = new SqlCommandBuilder(sqlda);
DataSet ds = new DataSet();
//数据填充到DataSet中
sqlda.Fill(ds);
//取记录行数
ds.Tables[0].Rows.Count.ToString();
//取第4行,第1列记录
ds.Tables[0].Rows[3][0].ToString();