62,041
社区成员
发帖
与我相关
我的任务
分享
Datatable dt= new DBHelper().getDatatable(sql);//试试
没有当然点不出来
public datatable executeDatatable(string sqlText)
{
SqlDataCommand dbCommand = new SqlDataCommand();
dbCommand.CommandText = sqlText;
return new DAL.DBHelper().executeDatatable(dbCommand); //这个方法里面应该要绑定SqlConntection对象
}
/// <summary>
/// 表查询
/// </summary>
/// <param name="safeSql"></param>
/// <returns>数据表</returns>
public static DataTable GetDataTable(string safeSql)
{
using (SqlConnection conn = new SqlConnection(myStr))
{
DataSet ds = null;
SqlDataAdapter sda = null;
try
{
ds = new DataSet();
sda = new SqlDataAdapter(safeSql, conn);
sda.Fill(ds);
}
catch (System.Data.SqlClient.SqlException ex)
{
throw new Exception(ex.Message);
}
return ds.Tables[0];
}
}