执行insert into语句的问题
OleDbConnection con = new OleDbConnection();
private void OpenDatabase()
{
con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("book.mdb");
con.Open();
}
private void Buttonok_Click(object sender, System.EventArgs e)
{
OleDbConnection myConnection = con;
OleDbCommand cmd;
string sql = "insert into [f_bbs] (f_name,head,f_content,f_oicq,f_email,f_homepage) values ('{0}','{1}','{2}','{3}','{4}','{5}')";
sql = string.Format(sql,this.TextBoxname.Text,this.Rblist.SelectedItem.Value,this.nr.Text,this.TextBoxoicq.Text,this.TextBoxmail.Text,this.TextBoxurl.Text);
cmd = new OleDbCommand(sql,myConnection);
try
{
cmd.ExecuteScalar();
}
catch
{
con.Close();
}
不会报错,就是插不进去数据。我将sql用response打出来,然后到数据库里执行就可以。谁看看哪的问题
private void OpenDatabase()
{
con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("book.mdb");
con.Open();
}
private void Buttonok_Click(object sender, System.EventArgs e)
{
OleDbConnection myConnection = con;
OleDbCommand cmd;
string sql = "insert into [f_bbs] (f_name,head,f_content,f_oicq,f_email,f_homepage) values ('{0}','{1}','{2}','{3}','{4}','{5}')";
sql = string.Format(sql,this.TextBoxname.Text,this.Rblist.SelectedItem.Value,this.nr.Text,this.TextBoxoicq.Text,this.TextBoxmail.Text,this.TextBoxurl.Text);
cmd = new OleDbCommand(sql,myConnection);
try
{
cmd.ExecuteScalar();
}
catch
{
con.Close();
}
不会报错,就是插不进去数据。我将sql用response打出来,然后到数据库里执行就可以。谁看看哪的问题
...全文
相关推荐
MySQL Insert Into 添加数据.docx
MySQL Insert Into 添加数据.docx
Insert into select语句把生产服务器炸了,Insert into select非常慢时如何优化
insert into select 的优化方案,当数据量比较大时候可以优化提高效率
MYSQL SELECT INTO 和 INSERT INTO SELECT
关于MySQL中“SELECT INTO”和“INSERT INTO SELECT”两种语法的使用与说明。
excel文件中批量生成insert语句
excel文件中批量生成insert语句,为了初始化导入数据库里面的数据,如导入期初库存或者商品档案,员工数据等等
将sqlserver表中指定数据转化为insert语句
将sqlserver表中指定数据转化为insert语句 部分数据类型固定不出现,自增列不出现


