what error did you get? is the path to the database corrrect? if you are using ASP.NET, you need to use Server.MapPath, if you are using winform, you need to use Application.StartupPath before the db file name:string strconn="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=mmedia.mdb";
also use a parameterized query instead, or try string strInsert = " INSERT INTO userinfo ( username , callnum , useradress , usertype , creatdate ) VALUES ( '" ;
strInsert += textBox1.Text + "', '" ;
strInsert += textBox2.Text + "', '" ;
strInsert += textBox3.Text + "', '" ;
strInsert += textBox4.Text + "', '" ;
strInsert += textBox5.Text + "')" ;
also use a parameterized query instead, or try string strInsert = " INSERT INTO userinfo ( username , callnum , useradress , usertype , creatdate ) VALUES ( '" ;
strInsert += textBox1.Text + "', '" ;
strInsert += textBox2.Text + "', '" ;
strInsert += textBox3.Text + "', '" ;
strInsert += textBox4.Text + "', '" ;
strInsert += textBox5.Text + "')" ;
解决方案 »
- C# 删除picturebox中的图片
- Mschart属性设置
- 在WinFrom开发中使用删除Ribbon控件是出现“将对象设置引用到对象的实例”错误
- 我的form1设计窗口怎么不在了?
- ASP.NET中怎么把服务器上生成的EXCEL推送到客户端下载
- 为什么提示我找不到命名空间?大家帮我
- 请教如何将数据从文本中提取出来
- datatable写入access的疑问
- 高分求助Access数据库的数据访问层
- $(this).parent().hide().next().show();怎么弄才不会把里面的html标签隐藏掉
- 关于提交数据总是出错,烦!
- 导出到数据到Excel的问题??"001011"变成了"1011"
#1992-9-9#所以代码:strInsert += textBox5.Text + ")" ;
应该这样
strInsert += "#";
strInsert += textBox5.Text;
strInsert += "#";
strInsert += " )"
的。
TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "')"
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr)
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
at UserManager.Form3.button1_Click(Object sender, EventArgs e) in e:\vc++\usermanager\form3.cs:line 245。
private void button1_Click(object sender, System.EventArgs e)
{
try
{
if (textBox1.Text!=""&&textBox2.Text!=""&&textBox3.Text!=""&&textBox4.Text!=""&&textBox5.Text!="")
{
string T_str="Provider =Microsoft.Jet.OLEDB.4.0;Data Source=mmedia.mdb";
OleDbConnection T_conn=new OleDbConnection(T_str);
T_conn.Open();
string T_insert="Insert into userinfo(username,callnum) Value('" +textBox1.Text+ "','" +textBox2.Text+ "')";
OleDbCommand T_command=new OleDbCommand(T_insert,T_conn);
T_command.ExecuteNonQuery();
T_conn.Close();
Label lb1=new Label();
lb1.Location=new Point(button1.Location.X,button1.Location.Y-10);
lb1.ForeColor=Color.Red;
lb1.Text="你已经成功的添加了数据!";
this.Controls.Add(lb1);
textBox1.Text="";
textBox2.Text="";
textBox3.Text="";
textBox4.Text="";
textBox5.Text="";
}
else
MessageBox.Show("必须填满所有字段值","错误!"); }
catch(Exception ed)
{
MessageBox.Show("保存数据记录发生错误"+ed.ToString(),"错误!");
}
}
呵呵,揭帖,都有份。