简单INSERT语句插入数据库问题.

来源:百度知道 编辑:UC知道 时间:2024/07/07 11:59:34
郁闷的要命,在其它页面这些语句正常运行,而这个就是插不进去,真的快疯了!

代码如下:
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;

protected void Button1_Click(object sender, EventArgs e)
{
string t1 = TextBox1.Text.Trim();
string t2 = TextBox2.Text.Trim();

string dbpath = System.Configuration.ConfigurationSettings.AppSettings["dbpath"];
OleDbConnection conn = new OleDbConnection("Provider=Microsoft.jet.OLEDB.4.0;Data source=" + Server.MapPath(dbpath));
conn.Open();
string sle2 = "select * from tadmin where adminid='" + t1 + "'";
OleDbCommand cmd2 = new OleDbComma

INSERT INTO tadmin([AdminID], [Password]) VALUES (\'" + t1 + "\', \'" + t2 + "\')

帐号为和密码为的数据类型都是string吗?
\'"+t1+"\',\'"+t2+"\'
或者是单引号的问题?