读书人

新手:c#中oledb提交SQL语句有关问题请

发布时间: 2012-05-24 11:55:41 作者: rapoo

新手: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的

读书人网 >C#

热点推荐