读取server数据库表信息
返回整张表数据
#region 获取书本列表
/// <summary>
/// 获取书本列表
/// </summary>
/// <returns>返回书本信息列表</returns>
public DataTable GetList()
{
using (SqlConnection conn = new SqlConnection(connStr))
{
conn.Open();
string sql = string.Format("select * from BooksB");
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataSet set = new DataSet();
adapter.Fill(set);
DataTable table = set.Tables[0];
return table;
}
}
#endregion