111,125
社区成员
发帖
与我相关
我的任务
分享
Form1:
private void Form1_Load(object sender, EventArgs e)
{
Initalize();
}
public void Initalize()
{
string str = @"select UserName 姓名,UserAge 年龄 from TEST";
DataTable dt = OracleHelper.ExecuteDataTable(CommandType.Text, str);
this.ucGrid1.DataSource = dt;
this.ucGrid1.DataBind();
}
Form2:
private void btnSave_Click(object sender, EventArgs e)
{
try
{
int flag = InsertData();
if (flag > 0)
{
MessageBox.Show("插入成功");
new Form1().Initalize();//在此处设断点,可以跟踪到Form1中的dt是变化了的,就是不能及时更新ucGrid1
}
else
{
MessageBox.Show("插入失败");
}
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private int InsertData()
{
string insertText = @"insert into TEST(username,userage)
values(:username,:userage)";
OracleParameter[] parm ={
new OracleParameter(":username",this.txtName.Text),
new OracleParameter(":userage",Convert.ToInt32(txtAge.Text.Trim()))
};
int flag = OracleHelper.ExecuteNonQuery(insertText, parm);
return flag;
}