[code=C#] OleDbConnection de=db.Crate();
de.Open();
string sql = "insert into [add]([title],tex,QQ) values(@title,@tex,@QQ)";
OleDbParameter[] parm ={
new OleDbParameter("@title",TextBox1.Text.ToString()),
new OleDbParameter("@tex",TextBox2.Text.ToString()),
new OleDbParameter("@QQ",TextBox3.Text.ToString()),
};
OleDbCommand er = new OleDbCommand(sql, de);
foreach (OleDbParameter pm in parm)//漏写了这一段。。
{
er.Parameters.Add(pm);
}
er.ExecuteNonQuery();
Label1.Text = "添加成功!";
[code]
成功后怎么打印SQL是 insert into [add]([title],tex,QQ) values(@title,@tex,@QQ)
参数@title 没值?不是很理解,大家帮忙解释一下~~~
de.Open();
string sql = "insert into [add]([title],tex,QQ) values(@title,@tex,@QQ)";
OleDbParameter[] parm ={
new OleDbParameter("@title",TextBox1.Text.ToString()),
new OleDbParameter("@tex",TextBox2.Text.ToString()),
new OleDbParameter("@QQ",TextBox3.Text.ToString()),
};
OleDbCommand er = new OleDbCommand(sql, de);
foreach (OleDbParameter pm in parm)//漏写了这一段。。
{
er.Parameters.Add(pm);
}
er.ExecuteNonQuery();
Label1.Text = "添加成功!";
[code]
成功后怎么打印SQL是 insert into [add]([title],tex,QQ) values(@title,@tex,@QQ)
参数@title 没值?不是很理解,大家帮忙解释一下~~~
ADD是表
title 对应@title
不知道理解我的意思不?