新手:c#中oledb提交SQL语句问题请指点
using System;
using System.Data;
using System.Data.OleDb;
namespace test{
     class Program
     {
         static void Main(string[] args)
         {              
             OleDbConnection con = new OleDbConnection();  
             OleDbCommand cmd = new OleDbCommand();
             OleDbDataAdapter dapter = new OleDbDataAdapter();
             String conStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= D:\\1.mdb";
             con.ConnectionString = conStr;
             con.Open();
             cmd.Connection = con;
             String SQLStr = "if object_id(N'detectingCannalId') is Null create table detectingCannalId(detectingNo varchar(20) not null,cannalId int not null,checked bit not null default 0 )";
             cmd.CommandText = SQLStr;
             cmd.CommandType = CommandType.Text;              
             cmd.ExecuteNonQuery();
         }
     }
     }
SQLStr = "if object_id(N'detectingCannalId') is Null create table detectingCannalId(detectingNo varchar(20) not null,cannalId int not null,checked bit not null default 0 )";
不可执行
SQLStr = "create table detectingCannalId(detectingNo varchar(20) not null,cannalId int not null,checked bit not null default 0 )";
可执行
该如何做给可行代码,拒绝无完整且正确语句的概念介绍。
------解决方案--------------------
object_id这是sqlserver的,不是access的