这是我现有代码
//定义一个insert方法,在下面的BUtton调用
public int Insert(string code, string mei, string counter, string record_shsa, string record_koushsa, string record_sacusc, string record_ksnc)
{
OracleConnection conn = new OracleConnection(@"Data Source= O10G;User ID=aws;Password=aws");
conn.Open();
string sql = "insert into T_SHIIRESAKIMASTER values (:code2,:mei,:counter,:record_shsa,:record_koushsa,:record_sacusc,:record_ksnc)";
OracleCommand cmd = new OracleCommand(sql, conn);
OracleParameter parn = new OracleParameter(":code2", code);
cmd.Parameters.Add(parn);
OracleParameter parp = new OracleParameter(":mei", mei);
cmd.Parameters.Add(parp);
OracleParameter part = new OracleParameter(":counter", counter);
cmd.Parameters.Add(part);
OracleParameter parm = new OracleParameter(":record_shsa", record_shsa);
cmd.Parameters.Add(parm);
OracleParameter pare = new OracleParameter(":record_koushsa", record_koushsa);
cmd.Parameters.Add(pare);
OracleParameter parr = new OracleParameter(":record_sacusc", record_sacusc);
cmd.Parameters.Add(parr);
OracleParameter parc = new OracleParameter(":record_ksnc", record_ksnc);
cmd.Parameters.Add(parc);
int result = cmd.ExecuteNonQuery();
conn.Close();
cmd.Dispose();
return result;
}
添加按钮BUtton代码
private void button1_Click(object sender, EventArgs e)
{
Insert(txtShiiresakiMei2.Text, textSHIIRESAKICODE2.Text, "0", System.Net.Dns.GetHostName(), System.Net.Dns.GetHostName(), DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
// insert into 表 (列1,列2) values ('" + ds.Tables[0].Rows[i][0].ToString() + "','" + ds.Tables[0].Rows[i][1].ToString() + "')
MessageBox.Show(" 顧客名前:'" + textSHIIRESAKICODE2.Text + "' 顧客コート: '" + txtShiiresakiMei2.Text + "'添加する");
Form1 f1 = new Form1();
this.Close();
}
问题 : 这是form2中,datagridview在form1中,点击form1中的添加按钮,弹出form2,在form2中进行真正的添加,在添加完成后,怎样自动刷新form1中的datagridview
求指导·····多谢!!