private void Plan_Load(object sender, EventArgs e) { //最大化窗体 this.MaximizedBounds = Screen.PrimaryScreen.WorkingArea; this.WindowState = FormWindowState.Maximized; string sql = "select * from ls_mes_plan"; DataSet ds = SqlDesigner.ExecuteDataSet(sql); DataTable dt = ds.Tables[0]; gridControl1.DataSource = dt; }
private void button1_Click(object sender, EventArgs e) { int i = SqlDesigner.ExecuteNoQuery("insert into ls_mes_plan(gongdan,lot,qty,pro,gongyi) values('" + textBox1.Text + "',20180716," + textBox3.Text + ",'" + textBox2.Text + "'," + textBox4.Text + ")"); if (i > 0) { MessageBox.Show("数据添加成功"); //更新数据源 string sql = "select * from ls_mes_plan"; DataSet ds = SqlDesigner.ExecuteDataSet(sql); DataTable dt = ds.Tables[0]; gridControl1.DataSource = dt; } else { MessageBox.Show("数据添加不成功"); } }