62,047
社区成员
发帖
与我相关
我的任务
分享
protected void Page_Load(object sender, EventArgs e)
{
string sql = "select QQ from table";
DataTable dt = new DataTable();
dt = ReturnDataTable(sql);
for (int i = 0; i < dt.Rows.Count; i++)
{
Response.Write(dt.Rows[i]["QQ"].ToString() + "<br/>");
}
}
public static DataTable ReturnDataTable(string cmdtext)
{
SqlConnection cn = new SqlConnection();
cn.ConnectionString = "链接字符串";
cn.Open();
SqlCommand cmd = new SqlCommand();
DataTable dt = new DataTable();
cmd = new SqlCommand(cmdtext, cn);
SqlDataReader dr = null;
using (dr = cmd.ExecuteReader(CommandBehavior.CloseConnection))
{
dt.Load(dr);
}
return dt;
}