添加Access的问题,在线等,急
总是说我Insert语句错误,高手看看,到底问题在那,蛋疼了!
string sql = "insert into InsertInfo(name,model,unit,count,price,sumprice,stockunits,remark,type,time)values(?,?,?,?,?,?,?,?,?,?);";
OleDbParameter[] parameters = new OleDbParameter[10];
parameters[0] = new OleDbParameter("@name", OleDbType.VarChar);
parameters[0].Value = p.Name;
parameters[1] = new OleDbParameter("@model", OleDbType.VarChar);
parameters[1].Value = p.Model;
parameters[2] = new OleDbParameter("@unit", OleDbType.VarChar);
parameters[2].Value = p.Unit;
parameters[3] = new OleDbParameter("@count", OleDbType.VarChar);
parameters[3].Value = p.Count;
parameters[4] = new OleDbParameter("@price", OleDbType.VarChar);
parameters[4].Value = p.Price;
parameters[5] = new OleDbParameter("@sumprice", OleDbType.VarChar);
parameters[5].Value = p.Sumprice;
parameters[6] = new OleDbParameter("@stockunits", OleDbType.VarChar);
parameters[6].Value = p.Stockunits;
parameters[7] = new OleDbParameter("@remark", OleDbType.VarChar);
parameters[7].Value = p.Remark;
parameters[8] = new OleDbParameter("@type", OleDbType.VarChar);
parameters[8].Value = p.Type;
parameters[9] = new OleDbParameter("@time", OleDbType.Date);
parameters[9].Value = p.Time;
return AccessDBUtil.ExecuteInsert(sql, parameters);
public static int ExecuteInsert(string sql,OleDbParameter[] parameters)
{
using (OleDbConnection connection = new OleDbConnection(connectionString))
{
OleDbCommand cmd = new OleDbCommand(sql, connection);
try
{
connection.Open();
if(parameters!=null) cmd.Parameters.AddRange(parameters);
cmd.ExecuteNonQuery();//执行到这里出错!
cmd.CommandText = @"select @@identity";
int value = Int32.Parse(cmd.ExecuteScalar().ToString());
return value;
}
catch (Exception e)
{
throw e;
}
}
}
在Access中,还有一个字段ID,设为自动编号!求高手秒杀我的问题啊。。!