数据库能读 不能写
public partial class Default3 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button2_Click(object sender, EventArgs e)
{
OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = (ConfigurationManager.ConnectionStrings["ConnStr"]).ToString();
conn.Open();
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = conn;
cmd.CommandText = "select * from 会员";
OleDbDataReader read = cmd.ExecuteReader();
while (read.Read())
{
if (TextBox1.Text.Trim() == read.GetString(0))
{
Label3.Text = "该用户名已存在";
break;
}
else Label3.Text = "该用户名可用";
}
read.Close();
conn.Close();
}
protected void Button1_Click(object sender, EventArgs e)
{
OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = (ConfigurationManager.ConnectionStrings["ConnStr"]).ToString();
conn.Open();
OleDbDataAdapter da = new OleDbDataAdapter();
da.InsertCommand = new OleDbCommand();
da.InsertCommand.CommandText = "insert into 会员(username,password) values(?,?)";
da.InsertCommand.Connection = conn;
da.InsertCommand.Parameters.Add( new OleDbParameter("@username",OleDbType.VarChar,20));
da.InsertCommand.Parameters.Add( new OleDbParameter("@password", OleDbType.VarChar, 20));
da.SelectCommand = new OleDbCommand();
da.SelectCommand.Connection = conn;
da.SelectCommand.CommandText = " select * from 会员";
DataSet ds = new DataSet();
da.Fill(ds, "会员");
da.InsertCommand.Parameters["@username"].Value = TextBox1.Text;
da.InsertCommand.Parameters["@password"].Value = TextBox2.Text;
da.Update(ds, "会员");
Response.Redirect("Default5.aspx");
button2可以执行,但1执行也通过,就是写不到数据库?
protected void Button1_Click(object sender, EventArgs e)
{
OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = (ConfigurationManager.ConnectionStrings["ConnStr"]).ToString();
conn.Open();
OleDbCommand cmd = new OleDbCommand();
cmd.CommandText = "insert into 会员(username,password) values(?,?)";
cmd.Connection = conn;
cmd.Parameters.Add( new OleDbParameter("@username",OleDbType.VarChar,20));
cmd.Parameters.Add( new OleDbParameter("@password", OleDbType.VarChar, 20));
cmd.Parameters["@username"].Value = TextBox1.Text;
cmd.Parameters["@password"].Value = TextBox2.Text;
cmd.ExecuteNonQuery();
Response.Redirect("Default5.aspx");
}
这样出现插入语句错误!身门原因 ?