c#基础链接数据库查询表

直接上代码
public class WeChatDao
{
//声明字符串
string connectionString = @“server=. ;uid=sa;pwd=****;database=Service1”;
public void ToPublic()
{
//声明集合对象
List<WX_SUser> wx = new List<WX_SUser>();
//声明链接
SqlConnection con = new SqlConnection(connectionString);
//操作SQL
string sql = “select * from WX_SUser”;
//声明适配器对象
SqlDataAdapter da = new SqlDataAdapter(sql, con);
//声明DataTable
DataTable trable = new DataTable();
//填充数据
da.Fill(trable);
//遍历到集合中
WX_SUser w = new WX_SUser();
foreach (DataRow row in trable.Rows)
{
w.CustomerId = Convert.ToInt32(row[“CustomerId”]);
w.Sex = Convert.ToInt32(row[“Sex”]);
w.IsEnabled = Convert.ToInt32(row[“IsEnabled”]);
w.CreatedTime = Convert.ToDateTime(row[“CreatedTime”]);
w.ModifiedTime = Convert.ToDateTime(row[“ModifiedTime”]);
w.IsDeleted = Convert.ToInt32(row[“IsDeleted”]);
wx.Add(w);
}

    }