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