vs连接SQL server 的语句
static public DataTable db()
{
DataTable dt = new DataTable();
string sql = "select [XX],[XXXX from [数据库名称].[dbo].[表名称] where 列名='列名中一项名称'";
SqlConnection conn = new SqlConnection( "server=.;database =数据库名称;integrated security=SSPI");
conn.Open();
SqlCommand cmd = new SqlCommand(sql,conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
return dt;
}