//连接数据库
string SQLCONNECT = @"server=.;database=zn_db;uid=sa;pwd=password";
SqlConnection conn = new SqlConnection(SQLCONNECT);
conn.Open();
//连接数据库之后就可以执行SQL命令了
//使用SqlCommand类的ExecuteReader()返回执行的结果
string SQLCOMMAND = "select * from tb_ZhiWu";
SqlDataAdapter da = new SqlDataAdapter(SQLCOMMAND, conn);
DataSet ds = new DataSet();
da.Fill(ds);
Console.WriteLine( ds.Tables[0].Rows[0]["zwm"].ToString().Trim());
Console.Read();
conn.Close();
string SQLCONNECT = @"server=.;database=zn_db;uid=sa;pwd=password";
SqlConnection conn = new SqlConnection(SQLCONNECT);
conn.Open();
//连接数据库之后就可以执行SQL命令了
//使用SqlCommand类的ExecuteReader()返回执行的结果
string SQLCOMMAND = "select * from tb_ZhiWu";
SqlDataAdapter da = new SqlDataAdapter(SQLCOMMAND, conn);
DataSet ds = new DataSet();
da.Fill(ds);
Console.WriteLine( ds.Tables[0].Rows[0]["zwm"].ToString().Trim());
Console.Read();
conn.Close();