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 )";
可执行该如何做给可行代码,拒绝无完整且正确语句的概念介绍。
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 )";
可执行该如何做给可行代码,拒绝无完整且正确语句的概念介绍。
解决方案 »
- C#中网络编程,关于数据传输中的一些问题
- C/S客户端调用IE页面
- sql语句int型减null的问题
- SPREAD数据显示问题
- DataGrid控件添加了按扭列,但是按钮列的响应事件怎么弄?
- C#新手问一个调用dll问题。 在线等!!!
- datagird 在winform 下分页程序应该如何做,大家给个思路吧
- 有没有控件高手帮我解决一下啊 (From:控件难题,散分(100)(项目验收在即,有一难题请大家帮忙) )
- windows 98下打印错误,请帮助!
- 请问如何实现我方传送对方一参数,对方抓取相应的数据包,我方监听数据包执行相应的数据库操作!
- textbox回车跳转到button
- VS上,ListBox控件怎么没有Paint事件
Dim rstSchema As New ADODB.Recordset
Set rstSchema = cn.OpenSchema(adSchemaTables)
rstSchema.Find "TABLE_NAME= '" & findTable &"'"
If rstSchema.EOF Then
TableExists= False
Else
TableExists = True
End If
rstSchema.Close
End Function好像大家推荐以上方式处理OLEDB
这代码对ACCESS,SQLSERVER,ORACEL都能用么??