中国IT动力,最新最全的IT技术教程
最新100篇 | 推荐100篇 | 专题100篇 | 排行榜 | 搜索 | 在线API文档 | 网通镜像
首 页 | 程序开发 | 操作系统 | 软件应用 | 图形图象 | 网络应用 | 精文荟萃 | 教育认证 | 硬件维护 | 未整理篇 | 站长教程
ASP JS PHP工程 ASP.NET 网站建设 UML J2EESUN .NET VC VB VFP 网络维护 数据库 DB2 SQL2000 Oracle Mysql
服务器 Win2000 Office C DreamWeaver FireWorks Flash PhotoShop 上网宝典 CorelDraw 协议大全 网络安全 微软认证
硬件维护  CPU  主板  硬盘  内存  显卡  显示器  键盘鼠标  声卡音箱  打印机  机箱电源  BIOS  网卡  C#  Java  Delphi  vs.net2005
  当前位置:> 程序开发 > Web开发 > Asp > 综合文章
[ASP.NET]对Oracle数据库创建表/判断数据表是否已存在
作者:未知 时间:2005-01-05 12:12 出处:Blog 责编:chinaitpower
              摘要:暂无

对Oracle数据库创建表:
        Dim myConnectionString As String
        Dim myConnection As OleDbConnection
        Dim myCommand As OleDbCommand
        Dim myCreateSQL As String
        myConnectionString = "Provider='OraOLEDB.Oracle.1';User ID=[User ID];Data Source=[Data Source];Extended Properties=;Persist Security Info=True;Password=[Password]"
        myConnection = New OleDbConnection(myConnectionString)
        myCreateSQL = "create table (abc varchar2(10))"
        myCommand = New OleDbCommand(myCreateSQL)

        myCommand.Connection = myConnection
        myConnection.Open()
        myCommand.ExecuteNonQuery()
        myCommand.Connection.Close()

判断数据表是否已存在:
'DataBaseName --表名
    Private Function SQLExistDatabase(ByVal DataBaseName As String) As Boolean
        Dim orcConnDb As OracleConnection
        Dim strSelect As String
        Dim odaExistDatabase As OracleDataAdapter
        Dim dsExistDatabase As New DataSet

        orcConnDb = New OracleConnection
        orcConnDb.ConnectionString = "data source=[data source];" _
                                    & "persist security info=False;" _
                                    & "user id=[]user id;Password=[Password];"
        orcConnDb.Open()

        strSelect = "select count(*) from user_tables where table_name='" & ReplaceEN(DataBaseName) & "'"
        odaExistDatabase = New OracleDataAdapter(strSelect, orcConnDb)

        odaExistDatabase.Fill(dsExistDatabase)

        If dsExistDatabase.Tables(0).Rows(0)(0) = 0 Then
            orcConnDb.Close()
            Return False
        Else
            orcConnDb.Close()
            Return True
        End If
    End Function

'小写英字转换成大写英字
'enString -- 字符串
    Private Function ReplaceEN(ByVal enString As String) As String
        Dim i As Integer

        For i = Asc("a") To Asc("z")
            enString = enString.Replace(CChar(ChrW(i)), CChar(ChrW(i - 32)))
        Next

        Return enString
    End Function

关闭本页
 
首页 | 投资与合作 | 服务条款 | 隐私政策 | 收藏本站 | 设为首页 | 新用户注册 | 免责声明 | 使用帮助
Copyright ©2005-2008 chinaitpower.com All rights reserved. www.chinaitpower.com 版权所有