String xh = xuehao.Text.Trim();
String xm = xingming.Text.Trim();
String xb = xingbie.Text.Trim();
String nj = jibie.Text.Trim();
String zy = zhuanye.Text.Trim();
String xz = xuezhi.Text.Trim();
String dz = dizhi.Text;
String nian ;
if ((nianling.Text.Equals("")) || (nianling.Text == null) || (nianling.Text == ""))
{
nian = "0";
}
else
{
nian = nianling.Text.Trim();
}
int nl = Int32.Parse(nian);
String zz = zhengzhi.Text.Trim();
String mz = minzu.Text.Trim();
String tx = tuixue.Text.Trim();
int = -1; if (IsExist(xh))
{
MessageBox.Show(this, "添加出错! 已经注册过了,不允许重复添加");
}
else
{
try
{
// conn = new OleDbConnection("Data Source=infodb.mdb;Jet OLEDB:Engine Type=5;Provider=Microsoft.Jet.OLEDB.4.0");
conn.Open();
String insertSql = "insert into stuinfo(stNum,stName,stSex,stGrade,stMajor,stXue,stAddr,stAge,stTitle,stNation,stBack)"
+" values('" + xh + "','" + xm + "','" + xb + "','" + nj + "','" + zy + "','" + xz + "','" + dz + "'," + nl + ",'" + zz + "','" + mz + "','" + tx + "')";
OleDbCommand comm = new OleDbCommand("", conn);
comm.CommandText = insertSql;
= comm.ExecuteNonQuery();
}
catch (Exception meec) {
MessageBox.Show(this, meec.Message.ToString());
}
finally
{
conn.Close();
}
if ( < 0)
{ MessageBox.Show(this, "添加失败");
}
else
{
MessageBox.Show(this, "添加成功");
}
}上面是做winform程序,插入数据到access的代码,代码没有任何异常,我在当前窗口上还添加了一个,datagridview和两个个按钮,一个按钮可以查看所有信息,另一个点击后进行插入操作,现在点击添加按钮后,出现插入成功,并且点击 显示信息 按钮,还能在gridview里面发现有新添加项目,但是不知道为什么,关闭当前窗口,进入到数据库中发现,没有任何更新,郁闷,这是课程设计,没几天了,希望大家能给个提示,或者给个别的更新数据的方法。。在线等............
String xm = xingming.Text.Trim();
String xb = xingbie.Text.Trim();
String nj = jibie.Text.Trim();
String zy = zhuanye.Text.Trim();
String xz = xuezhi.Text.Trim();
String dz = dizhi.Text;
String nian ;
if ((nianling.Text.Equals("")) || (nianling.Text == null) || (nianling.Text == ""))
{
nian = "0";
}
else
{
nian = nianling.Text.Trim();
}
int nl = Int32.Parse(nian);
String zz = zhengzhi.Text.Trim();
String mz = minzu.Text.Trim();
String tx = tuixue.Text.Trim();
int = -1; if (IsExist(xh))
{
MessageBox.Show(this, "添加出错! 已经注册过了,不允许重复添加");
}
else
{
try
{
// conn = new OleDbConnection("Data Source=infodb.mdb;Jet OLEDB:Engine Type=5;Provider=Microsoft.Jet.OLEDB.4.0");
conn.Open();
String insertSql = "insert into stuinfo(stNum,stName,stSex,stGrade,stMajor,stXue,stAddr,stAge,stTitle,stNation,stBack)"
+" values('" + xh + "','" + xm + "','" + xb + "','" + nj + "','" + zy + "','" + xz + "','" + dz + "'," + nl + ",'" + zz + "','" + mz + "','" + tx + "')";
OleDbCommand comm = new OleDbCommand("", conn);
comm.CommandText = insertSql;
= comm.ExecuteNonQuery();
}
catch (Exception meec) {
MessageBox.Show(this, meec.Message.ToString());
}
finally
{
conn.Close();
}
if ( < 0)
{ MessageBox.Show(this, "添加失败");
}
else
{
MessageBox.Show(this, "添加成功");
}
}上面是做winform程序,插入数据到access的代码,代码没有任何异常,我在当前窗口上还添加了一个,datagridview和两个个按钮,一个按钮可以查看所有信息,另一个点击后进行插入操作,现在点击添加按钮后,出现插入成功,并且点击 显示信息 按钮,还能在gridview里面发现有新添加项目,但是不知道为什么,关闭当前窗口,进入到数据库中发现,没有任何更新,郁闷,这是课程设计,没几天了,希望大家能给个提示,或者给个别的更新数据的方法。。在线等............
OleDbCommand comm = new OleDbCommand(insertSql, conn);
comm.CommandText = insertSql;