至少一个参数没有被指定值。
点击添加按钮事件的时候也出现了这个问题,很简单的一段代码应该没问题的哦!
而且id是自动增长的,应该用不着吧?
代码 Models.clientorder model = new Models.clientorder();
model.Projname = this.txtprojname.Text;
model.Clientname = this.txtclientname.Text;
model.Orderdate = Convert.ToDateTime(this.txtorderdate.Text);
model.Telphone = Convert.ToInt32(this.txttelphone.Text);
model.Email = this.txtemail.Text;
model.Finishdate = Convert.ToDateTime(this.txtfinishdate.Text);
OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.Jet.OleDb.4.0;Data Source=" + Server.MapPath("App_Data/ClientManage.mdb"));
conn.Open();
string strSql = "insert into clientorder (projname,clientname,orderdate,telphone,email,finishdate) values (" + txtprojname.Text + "," + txtclientname.Text + "," + txtorderdate.Text + "," + txttelphone.Text + "," + txtemail.Text + "," + txtfinishdate.Text + ")";
OleDbCommand cmd = new OleDbCommand(strSql, conn);
cmd.ExecuteNonQuery();
clientorder.Add(model);
conn.Close();
Response.Write("成功!");
大家帮忙看下,有什么遗漏的,access用的不熟!