怎么用asp创建sql数据表相关操作.doc

- - -.
. . 文档.
下面是利用sql语句创立数据库、表、存储过程、视图、索引、规那么、修改表、查看数据等的方法。所要增加的控件如下：
- - -.
. . 文档.
imports
imports
public class form1
  inherits
  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 sqlmand = nothing
  private altertablebtn as
  private sql as string = nothing
  private createothersbtn as
#region " windows 窗体设计器生成的代码 "
  窗体重写处置以清理组件列表。
  protected overloads overrides sub dispose(byval disposing as boolean)
    if disposing then
      if not (ponents is nothing) then
        ()
      end if
    end if
    (disposing)
  end sub
  public sub new()
    ()
    initializeponent()
  end sub
  private ponents as
  friend withevents datagrid1 as
  friend withevents createdbbtn as