WinForm绑定DataGridView

使用SplitContainer控件将屏幕分成两部分。

方式一：

直接使用绑定数据源

就可以用EF的形式绑定数据源了。

 可以添加列和编辑列

方式二：

采用手动连接MySQL数据库绑定数据源的方式。

https://blog.csdn.net/qq_43026206/article/details/86706431

 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();
     }
 }

调整列自适应宽度

https://www.cnblogs.com/wolf-sun/p/3480104.html