//如何读取数据库并绑定到dataGridview
public static DataTable SqlAdapterFill(string SelectString,DataTable Table )
{
SqlDataAdapter Adapter = new SqlDataAdapter();
using (SqlConnection connetion = new SqlConnection(connectionString))
{
Adapter.SelectCommand = new SqlCommand(SelectString, connetion);
Adapter.Fill(Table);
return Table;
}
}
//调用
String Sql = "select * from tablename";
DataTable mytable =new DataTable();
SqlAdapterFill(sql,mytable);
this.DataGridView1.DataSource = mytable;