public void showDate() { mysqlDB = new MysqlDB("49.235.232.46", 3306, "cement", "123456"); string sql = "select * from well"; var reader = mysqlDB.Get(sql); while (reader.Read()) { int index = this.dataGridView1.Rows.Add(); for (int i = 0; i < dataGridView1.Columns.Count; i++) { this.dataGridView1.Rows[index].Cells[i].Value = reader[i]; } } num.DataSource = mysqlDB.getWellNum(); }
public void showDate() { dataGridView1.Columns[6].DefaultCellStyle.Format = "yyyy-MM-dd hh:mm:ss"; mysqlDB = new MysqlDB("49.235.232.46", 3306, "cement", "123456"); string sql = "select * from 井眼轨迹表"; var reader = mysqlDB.Get(sql); while (reader.Read()) { int index = this.dataGridView1.Rows.Add(); for (int i = 0; i < dataGridView1.Columns.Count; i++) { this.dataGridView1.Rows[index].Cells[i].Value = reader[i]; } } //绑定数据集 num.DataSource = mysqlDB.getWellNum(); }
private void FrmInsert_Load(object sender, EventArgs e) { mysqlDB = new MysqlDB("49.235.232.46", 3306, "cement", "123456"); JingHao.DataSource = mysqlDB.getWellNum(); }