using System.Data.SqlClient;
using System.Data;
SqlConnection SqlCon=new SqlConnection("server =服务器;database =数据库;uid =帐号;pwd =密码");
public static DataTable GetTable(string select)
{
try
{
SqlDataAdapter da = new SqlDataAdapter(select, SqlCon);
DataTable dt = new DataTable();
da.Fill(dt);
return dt;
}
catch (Exception ex)
{
throw ex;
}
}
其中select 一般形式是 "select * from table"
该方法返回的是DataTable
温馨提示:答案为网友推荐,仅供参考