try
{
OleDbConnection ds = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0" + ";Data Source=H:\\c#\\图表\\实时历史信息表.mdb");
ds.Open();
OleDbCommand comd = new OleDbCommand();
comd.Connection = ds;
comd.CommandText = "INSERT INTO 历史信息表(EquID,EquLastOperate,PeoSim,PeoName,EquLastOperateStartTime,EquLastOperateEndTime,EquStolenNumber)VALUES('" + IDtextBox.Text + "','" + LastOperatetextBox.Text + "','" + PeoSimtextBox.Text + "','" + PeoNametextBox.Text + "','" + LastOperateStartetextBox.Text + "','" + LastOperateEndtextBox.Text + "'," + StolenNumbertextBox + ")";
comd.ExecuteNonQuery();
ds.Close(); }
catch (Exception ex)
{
MessageBox.Show(ex.Message);
MessageBox.Show("添加失败");
}
finally
{
}
老是出现查询值的 数目与目标字段中的数目不同
各位大侠给小弟解答下
下地感激不尽
{
OleDbConnection ds = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0" + ";Data Source=H:\\c#\\图表\\实时历史信息表.mdb");
ds.Open();
OleDbCommand comd = new OleDbCommand();
comd.Connection = ds;
comd.CommandText = "INSERT INTO 历史信息表(EquID,EquLastOperate,PeoSim,PeoName,EquLastOperateStartTime,EquLastOperateEndTime,EquStolenNumber)VALUES('" + IDtextBox.Text + "','" + LastOperatetextBox.Text + "','" + PeoSimtextBox.Text + "','" + PeoNametextBox.Text + "','" + LastOperateStartetextBox.Text + "','" + LastOperateEndtextBox.Text + "'," + StolenNumbertextBox + ")";
comd.ExecuteNonQuery();
ds.Close(); }
catch (Exception ex)
{
MessageBox.Show(ex.Message);
MessageBox.Show("添加失败");
}
finally
{
}
老是出现查询值的 数目与目标字段中的数目不同
各位大侠给小弟解答下
下地感激不尽
//对你的代码的一些建议:
try
{
OleDbConnection ds = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0" + ";Data Source=H:\\c#\\图表\\实时历史信息表.mdb");
ds.Open();
OleDbCommand comd = new OleDbCommand();
comd.Connection = ds;
comd.CommandText = "INSERT INTO 历史信息表(EquID,EquLastOperate,PeoSim,PeoName,EquLastOperateStartTime,EquLastOperateEndTime,EquStolenNumber)VALUES('" + IDtextBox.Text + "','" + LastOperatetextBox.Text + "','" + PeoSimtextBox.Text + "','" + PeoNametextBox.Text + "','" + LastOperateStartetextBox.Text + "','" + LastOperateEndtextBox.Text + "'," + StolenNumbertextBox.Text + ")";
if(comd.ExecuteNonQuery()>0) //1.此处添加判断
{
MessageBox.Show("添加成功");}
else
{
MessageBox.Show("添加失败");}
//ds.Close(); 2.此句放到finally{}里去 }
catch (Exception ex)
{
MessageBox.Show(ex.Message);
MessageBox.Show("添加失败");
}
finally
{
ds.Close();
}
检查数据类型,String.Format参数化
或oleDBparameter