动态创建SQL Server数据库、表、存储过程

•  

  下面是利用SQL语句创建数据库、表、存储过程、视图、索引、规则、修改表、查看数据等的方法。所要增加的控件如下：

  Imports System.Data
  Imports System.Data.SqlClient
  
  Public Class Form1
    Inherits System.Windows.Forms.Form
    Private ConnectionString As String = "Data Source=.;Initial Catalog=;User Id=sa;Password=;"
    Private reader As SqlDataReader = Nothing
    Private conn As SqlConnection = Nothing
    Private cmd As SqlCommand = Nothing
    Private AlterTableBtn As System.Windows.Forms.Button
    Private sql As String = Nothing
    Private CreateOthersBtn As System.Windows.Forms.Button
  
  #Region " Windows 窗体设计器生成的代码 "
    '窗体重写处置以清理组件列表。
    Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean)
      If disposing Then
        If Not (components Is Nothing) Then
          components.Dispose()
        End If
      End If
      MyBase.Dispose(disposing)
    End Sub
    Public Sub New()
      MyBase.New()
      InitializeComponent()
    End Sub
    Private components As System.ComponentModel.IContainer
    Friend WithEvents DataGrid1 As System.Windows.Forms.DataGrid
    Friend WithEvents CreateDBBtn As System.Windows.Forms.Button
    Friend WithEvents CreateTableBtn As System.Windows.Forms.Button
    Friend WithEvents CreateSPBtn As System.Windows.Forms.Button
    Friend WithEvents CreateViewBtn As System.Windows.Forms.Button
    Friend WithEvents btnAlterTable As System.Windows.Forms.Button
    Friend WithEvents btnCreateOthers As System.Windows.Forms.Button
  

• [1] [2] [3] [4] [5] [6] [7] [8] [9] [10] 下一页 
• 复制本页网址和标题，发送给你QQ/Msn的好友一起分享
  
  
• 动态创建SQL Server数据库、表、存储过程 相关文章：
• ·动态创建SQL Server数据库、表、存储过程
• 动态创建SQL Server数据库、表、存储过程 相关软件

上一篇:数据库中的命名规则

下一篇:Oracle SQL内置函数大全(一)

• 特别声明：本站除部分特别声明禁止转载的专稿外的其他文章可以自由转载，但请务必注明出处和原始作
• 者.文章版权归文章原始作者所有.对于被本站转载文章的个人和网站，我们表示深深的谢意。如果本站转
• 载的文章有版权问题请联系编辑人员,我们尽快予以更正. 转载请注明来源：http://www.hackhome.com

精品推荐

热点TOP10

特别推荐