加入收藏 | 设为首页 | 会员中心 | 我要投稿 李大同 (https://www.lidatong.com.cn/)- 科技、建站、经验、云计算、5G、大数据,站长网!
当前位置: 首页 > 站长学院 > MsSql教程 > 正文

创建动态SQL Server数据库表的简单示例

发布时间:2020-12-12 07:51:32 所属栏目:MsSql教程 来源:网络整理
导读:感兴趣的小伙伴,下面一起跟随编程之家 jb51.cc的小编两巴掌来看看吧! 以下是引用片段: 代码如下: ImportsSystem.Data ImportsSystem.Data.SqlClient PublicClassForm1 InheritsSystem.Windows.Forms.Form PrivateConnectionStringAsString=DataSource=.;I

感兴趣的小伙伴,下面一起跟随编程之家 52php.cn的小编两巴掌来看看吧!

以下是引用片段:

代码如下:


  ImportsSystem.Data 
  ImportsSystem.Data.SqlClient 
  PublicClassForm1 
  InheritsSystem.Windows.Forms.Form 
  PrivateConnectionStringAsString="DataSource=.;InitialCatalog=;UserId=sa;Password=;" 
  PrivatereaderAsSqlDataReader=Nothing 
  PrivateconnAsSqlConnection=Nothing 
  PrivatecmdAsSqlCommand=Nothing 
  PrivateAlterTableBtnAsSystem.Windows.Forms.Button 
  PrivatesqlAsString=Nothing 
  PrivateCreateOthersBtnAsSystem.Windows.Forms.Button 
  #Region"Windows窗体设计器生成的代码" 
  '窗体重写处置以清理组件列表。 
  ProtectedOverloadsOverridesSubDispose(ByValdisposingAsBoolean) 
  IfdisposingThen 
  IfNot(componentsIsNothing)Then 
  components.Dispose() 
  EndIf 
  EndIf 
  MyBase.Dispose(disposing) 
  EndSub 
  PublicSubNew() 
  MyBase.New() 
  InitializeComponent() 
  EndSub 
  PrivatecomponentsAsSystem.ComponentModel.IContainer 
  FriendWithEventsDataGrid1AsSystem.Windows.Forms.DataGrid 
  FriendWithEventsCreateDBBtnAsSystem.Windows.Forms.Button 
  FriendWithEventsCreateTableBtnAsSystem.Windows.Forms.Button 
  FriendWithEventsCreateSPBtnAsSystem.Windows.Forms.Button 
  FriendWithEventsCreateViewBtnAsSystem.Windows.Forms.Button 
  FriendWithEventsbtnAlterTableAsSystem.Windows.Forms.Button 
  FriendWithEventsbtnCreateOthersAsSystem.Windows.Forms.Button 
  FriendWithEventsbtnDropTableAsSystem.Windows.Forms.Button 
  FriendWithEventsbtnViewDataAsSystem.Windows.Forms.Button 
  FriendWithEventsbtnViewSPAsSystem.Windows.Forms.Button 
  FriendWithEventsbtnViewViewAsSystem.Windows.Forms.Button 
  PrivateSubInitializeComponent() 


  

代码如下:


Me.CreateDBBtn=NewSystem.Windows.Forms.Button() 
  Me.CreateTableBtn=NewSystem.Windows.Forms.Button() 
  Me.CreateSPBtn=NewSystem.Windows.Forms.Button() 
  Me.CreateViewBtn=NewSystem.Windows.Forms.Button() 
  Me.btnAlterTable=NewSystem.Windows.Forms.Button() 
  Me.btnCreateOthers=NewSystem.Windows.Forms.Button() 
  Me.btnDropTable=NewSystem.Windows.Forms.Button() 
  Me.btnViewData=NewSystem.Windows.Forms.Button() 
  Me.btnViewSP=NewSystem.Windows.Forms.Button() 
  Me.btnViewView=NewSystem.Windows.Forms.Button() 
  Me.DataGrid1=NewSystem.Windows.Forms.DataGrid() 
  CType(Me.DataGrid1,System.ComponentModel.ISupportInitialize).BeginInit() 
  Me.SuspendLayout() 
  ' 
  'CreateDBBtn 
  ' 
  Me.CreateDBBtn.Location=NewSystem.Drawing.Point(19,9) 
  Me.CreateDBBtn.Name="CreateDBBtn" 
  Me.CreateDBBtn.Size=NewSystem.Drawing.Size(104,23) 
  Me.CreateDBBtn.TabIndex=0 
  Me.CreateDBBtn.Text="创建数据库" 
  ' 
  'CreateTableBtn 
  ' 
  Me.CreateTableBtn.Location=NewSystem.Drawing.Point(139,9) 
  Me.CreateTableBtn.Name="CreateTableBtn" 
  Me.CreateTableBtn.TabIndex=1 
  Me.CreateTableBtn.Text="创建表" 
  ' 
  'CreateSPBtn 
  ' 
  Me.CreateSPBtn.Location=NewSystem.Drawing.Point(230,9) 
  Me.CreateSPBtn.Name="CreateSPBtn" 
  Me.CreateSPBtn.Size=NewSystem.Drawing.Size(104,23) 
  Me.CreateSPBtn.TabIndex=2 
  Me.CreateSPBtn.Text="创建存储过程" 
  ' 
  'CreateViewBtn 
  ' 
  Me.CreateViewBtn.Location=NewSystem.Drawing.Point(350,9) 
  Me.CreateViewBtn.Name="CreateViewBtn" 
  Me.CreateViewBtn.TabIndex=3中国网管联盟www.bitscn.com 
  Me.CreateViewBtn.Text="创建视图" 
  ' 
  'btnAlterTable 
  ' 
  Me.btnAlterTable.Location=NewSystem.Drawing.Point(441,9) 
  Me.btnAlterTable.Name="btnAlterTable" 
  Me.btnAlterTable.TabIndex=4 
  Me.btnAlterTable.Text="修改表" 

(编辑:李大同)

【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!

推荐文章
    热点阅读