数据显示
在dataGridView 中显示当前数据库的数据
private void gridshow_Click(object sender, EventArgs e)
{
string P_Str_ConnectionStr = string.Format("server=localhost;port=3306;
database=proessinfo;user=haoyu;password=267282;Charset=utf8");
string P_Str_SqlStr = string.Format("SELECT id,sn,螺钉编号,time FROM tdata");
MySqlDataAdapter adapter = new MySqlDataAdapter(P_Str_SqlStr,P_Str_ConnectionStr);
DataTable P_dt = new DataTable();
adapter.Fill(P_dt);
this.dataGridView1.DataSource = P_dt;
}
界面文本框中输入数据并插入数据库,关键是文本框字符串的处理
string sqlstr = "insert into tdata(sn,螺钉编号,tts,user,TIME) values( '"+textBox_sn.Text+" ', '8' , '8.5' , 'why' , now())";
插入完成后,刷新显示,重新执行第一块代码