写了三个语句，请问这样有问题吗？

[touch_hand]

            String sql = "insert into compact_in(CNo,CName) values( '" + textBox1.Text  + "' , '" + textBox2.Text + "')";
     
            OleDbConnection connection = new OleDbConnection(sql);
         
            OleDbCommand.ExecuteNonQuery(); 

报错是：

错误 1 非静态的字段、方法或属性“System.Data.Common.DbCommand.ExecuteNonQuery()”要求对象引用 C:\Users\Administrator\Documents\Visual Studio 2005\Projects\WindowsApplication2\WindowsApplication2\Form1.cs 47 13 WindowsApplication2

[Pigeon汪]

要先new一个OleDbCommand

[D56233577]

三行有两行是错的。去看看OleDbConnection的重载是什么。

[郑州高新区WPF小王子]

OleDbConnection connection = new OleDbConnection(sql);
OleDbCommand command = new OleDbCommand(sql, connection);
connection.Open();
command.ExecuteNonQuery();

http://msdn.microsoft.com/zh-cn/library/system.data.oledb.oledbcommand(v=vs.110).aspx