c# datagridview 绑定mysql_c#简单的数据库查询与绑定DataGridView。

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