您所在位置：主题：请问用这段程序为什么不能实现插入功能
haryjiang
[专家分：0] 发布于 2006-07-16 15:29:00
string connStr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + HttpContext.Current .Server.MapPath (ConfigurationSettings.AppSettings["Data"]);
OleDbConnection conn=new OleDbConnection (connStr);
string strSql="insert into hiretable(user,time,hnumber,phone,looktime,consult) values(@user,@time,@hnumber,@phone,@looktime,@consult)";
OleDbCommand mycmd=new OleDbCommand(strSql,conn);
mycmd.Parameters.Add ("@user",user );
mycmd.Parameters.Add ("@time",time);
mycmd.Parameters.Add ("@hnumber",this.TextBox1.Text.ToString());
mycmd.Parameters.Add ("@phone",this.TextBox2.Text.ToString());
mycmd.Parameters .Add ("@looktime",this.TextBox3.Text.ToString());
mycmd.Parameters.Add ("@consult",this.TextBox4.Text.ToString());
conn.Open ();
mycmd.ExecuteNonQuery ();
//clearTextBox();
conn.Close ();
conn.Dispose ();
错误的是insert into语法错误
OleDbConnection conn=new OleDbConnection (connStr);
string strSql="insert into hiretable(user,time,hnumber,phone,looktime,consult) values(@user,@time,@hnumber,@phone,@looktime,@consult)";
OleDbCommand mycmd=new OleDbCommand(strSql,conn);
mycmd.Parameters.Add ("@user",user );
mycmd.Parameters.Add ("@time",time);
mycmd.Parameters.Add ("@hnumber",this.TextBox1.Text.ToString());
mycmd.Parameters.Add ("@phone",this.TextBox2.Text.ToString());
mycmd.Parameters .Add ("@looktime",this.TextBox3.Text.ToString());
mycmd.Parameters.Add ("@consult",this.TextBox4.Text.ToString());
conn.Open ();
mycmd.ExecuteNonQuery ();
//clearTextBox();
conn.Close ();
conn.Dispose ();
错误的是insert into语法错误
