执行insert into语句的问题

[Nils]

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打出来，然后到数据库里执行就可以。谁看看哪的问题

[apcsherry]

insert into f_bbs (f_name,head,f_content,f_oicq,f_email,f_homepage) Values ('{0}','{1}','{2}','{3}','{4}','{5}');

[xhyang0255]

insert into f_bbs (f_name,head,f_content,f_oicq,f_email,f_homepage) Values ('{0}','{1}','{2}','{3}','{4}','{5}');

[Nils]

还是一样。不是加不加[]的问题吧。SQL打印出来可以直接执行的。

[Firestone2003]

try{cmd.ExecuteScalar();}catch（Exceptionex）{MessageBox.Show(ex.Message);con.Close();}!

[LoveCherry]

Buttonok_Click还需要重新打开连接的

[hackate]

cmd = New SqlClient.SqlCommand("insert mn_admin(admin_name,admin_pass,fage,qx,quanxian) values(@admin_name,@admin_pass,@fage,@qx,@quanxian)", conn)
cmd.Parameters.Add("@admin_name", admin_user.Text.Trim)
...................//象这样格式的，用SQLCOMMAND的来，比你那个好
conn.Open()
cmd.ExecuteNonQuery()

象这样的，给你参考一下，应该不出问题

[Nils]

to LoveCherry(论成败，人生豪迈；大不了，重头再来！^_^)


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);
myConnection.Open();
cmd = new OleDbCommand(sql,myConnection);
try
{
cmd.ExecuteScalar();
}
catch
{
myConnection.Close();
}

在下面打开，是这个意思吗？ 还是不行啊

[Nils]

我已搞定了，谢谢各位帮忙，散分。。
把finally写成catch了