1配置文件 (两种写法)
string connStr1 = System.Configuration.ConfigurationManager.AppSettings["connStr"];
3.连接数据库,执行数据库操作,返回ds
private string Sql()//拼接数据库语句
{
string sql = "select * from test order by Id asc";
return sql;
}
private void btnGetData_Click(object sender, EventArgs e)
{
string sql = Sql();
SqlConnection conn = new SqlConnection(connStr);
conn.Open();
SqlCommand comm = new SqlCommand(sql, conn);
SqlDataAdapter dap = new SqlDataAdapter(comm);
DataSet ds = new DataSet();
dap.Fill(ds, "test");
conn.Close();
conn.Dispose();
success(ds);
}
4.绑定DataGridView
///
/// 把数据表转变为List
///
///
///
private List TableToList(DataTabl