方式一:
直接使用绑定数据源
就可以用EF的形式绑定数据源了。
可以添加列和编辑列
方式二:
采用手动连接MySQL数据库绑定数据源的方式。
string sql = "select id as 序号, userid as 用户,type as 实验类型,mixrate as 混合比例,initemp as 初始温度,testemp as 测试温度,inipress as 初始压力,testpress as 测试压力,result as 测试结果,datetime as 测试时间 FROM gas_charact";
DataSet dataSet = dbhelper.Select(sql);
dataGridView1.DataSource = dataSet.Tables[0];
this.dataGridView1.Columns[0].Width = 70;
this.dataGridView1.Columns[1].Width = 70;
this.dataGridView1.Columns[2].Width = 160;
for (int i = 3; i < this.dataGridView1.Columns.Count - 1; i++)
{
this.dataGridView1.Columns[i].Width = 76;
}
this.dataGridView1.Columns[this.dataGridView1.Columns.Count - 1].Width = 160;
public DataSet Select(string sql)
{
string[] s = sql.Trim().Split(' ');
MySqlConnection mycon = new MySqlConnection(connectionString);
try
{
if (mycon != null)
{
mycon.Open();
}
MySqlCommand sqlCmd = new MySqlCommand(sql, mycon);
MySqlDataAdapter sda = new MySqlDataAdapter(sqlCmd);
DataSet ds = new DataSet();
sda.Fill(ds, s[3]);
return ds;
}
catch (Exception exception)
{
throw new Exception("SelectMethod:" + exception.Message);
}
finally
{
mycon.Close();
}
}