《怎么用asp创建sql数据表及相关操作》由会员分享，可在线阅读，更多相关《怎么用asp创建sql数据表及相关操作（8页珍藏版）》请在金锄头文库上搜索。
1、下面是利用 sql 语句创建数据库、表、存储过程、视图、索引、规则、修改表、查看数据等的方法。所要增加的控件如下：imports system.dataimports system.data.sqlclientpublic class form1inherits system.windows.forms.formprivate connectionstring as string = “data source=.;initial catalog=;user id=sa;password=;“private reader as sqldatareader = nothingprivate con
2、n as sqlconnection = nothingprivate cmd as sqlcommand = nothingprivate altertablebtn as system.windows.forms.buttonprivate sql as string = nothingprivate createothersbtn as system.windows.forms.button#region “ windows 窗体设计器生成的代码 “窗体重写处置以清理组件列表。protected overloads overrides sub dispose(byval disposin
3、g as boolean)if disposing thenif not (components is nothing) thencomponents.dispose()end ifend ifmybase.dispose(disposing)end subpublic sub new()mybase.new()initializecomponent()end subprivate components as ponentmodel.icontainerfriend withevents datagrid1 as system.windows.forms.datagridfriend with
4、events createdbbtn as system.windows.forms.buttonfriend withevents createtablebtn as system.windows.forms.buttonfriend withevents createspbtn as system.windows.forms.buttonfriend withevents createviewbtn as system.windows.forms.buttonfriend withevents btnaltertable as system.windows.forms.buttonfrie
5、nd withevents btncreateothers as system.windows.forms.buttonfriend withevents btndroptable as system.windows.forms.buttonfriend withevents btnviewdata as system.windows.forms.buttonfriend withevents btnviewsp as system.windows.forms.buttonfriend withevents btnviewview as system.windows.forms.buttonp
6、rivate sub initializecomponent()me.createdbbtn = new system.windows.forms.button()me.createtablebtn = new system.windows.forms.button()me.createspbtn = new system.windows.forms.button()me.createviewbtn = new system.windows.forms.button()me.btnaltertable = new system.windows.forms.button()me.btncreat
7、eothers = new system.windows.forms.button()me.btndroptable = new system.windows.forms.button()me.btnviewdata = new system.windows.forms.button()me.btnviewsp = new system.windows.forms.button()me.btnviewview = new system.windows.forms.button()me.datagrid1 = new system.windows.forms.datagrid()ctype(me
8、.datagrid1, ponentmodel.isupportinitialize).begininit()me.suspendlayout()createdbbtnme.createdbbtn.location = new system.drawing.point(19, 9)me.createdbbtn.name = “createdbbtn“me.createdbbtn.size = new system.drawing.size(104, 23)me.createdbbtn.tabindex = 0me.createdbbtn.text = “创建数据库“createtablebtn
9、me.createtablebtn.location = new system.drawing.point(139, 9)me.createtablebtn.name = “createtablebtn“me.createtablebtn.tabindex = 1me.createtablebtn.text = “创建表“createspbtnme.createspbtn.location = new system.drawing.point(230, 9)me.createspbtn.name = “createspbtn“me.createspbtn.size = new system.d
10、rawing.size(104, 23)me.createspbtn.tabindex = 2me.createspbtn.text = “创建存储过程“createviewbtnme.createviewbtn.location = new system.drawing.point(350, 9)me.createviewbtn.name = “createviewbtn“me.createviewbtn.tabindex = 3me.createviewbtn.text = “创建视图“btnaltertableme.btnaltertable.location = new system.
11、drawing.point(441, 9)me.btnaltertable.name = “btnaltertable“me.btnaltertable.tabindex = 4me.btnaltertable.text = “修改表“btncreateothersme.btncreateothers.location = new system.drawing.point(17, 43)me.btncreateothers.name = “btncreateothers“me.btncreateothers.size = new system.drawing.size(104, 23)me.b
12、tncreateothers.tabindex = 5me.btncreateothers.text = “创建规则和索引“btndroptableme.btndroptable.location = new system.drawing.point(138, 43)me.btndroptable.name = “btndroptable“me.btndroptable.tabindex = 6me.btndroptable.text = “删除表“btnviewdatame.btnviewdata.location = new system.drawing.point(351, 43)me.
13、btnviewdata.name = “btnviewdata“me.btnviewdata.tabindex = 7me.btnviewdata.text = “查看数据“btnviewspme.btnviewsp.location = new system.drawing.point(230, 43)me.btnviewsp.name = “btnviewsp“me.btnviewsp.size = new system.drawing.size(104, 23)me.btnviewsp.tabindex = 8me.btnviewsp.text = “查看存储过程“btnviewview
14、me.btnviewview.location = new system.drawing.point(443, 43)me.btnviewview.name = “btnviewview“me.btnviewview.tabindex = 9me.btnviewview.text = “查看视图“datagrid1me.datagrid1.datamember = “me.datagrid1.headerforecolor = system.drawing.systemcolors.controltextme.datagrid1.location = new system.drawing.po
15、int(20, 76)me.datagrid1.name = “datagrid1“me.datagrid1.size = new system.drawing.size(500, 183)me.datagrid1.tabindex = 10form1me.autoscalebasesize = new system.drawing.size(5, 13)me.clientsize = new system.drawing.size(538, 281)me.controls.addrange(new system.windows.forms.control() me.datagrid1, me
16、.btnviewview, _me.btnviewsp, me.btnviewdata, me.btndroptable, me.btncreateothers, me.btnaltertable, _me.createviewbtn, me.createspbtn, me.createtablebtn, me.createdbbtn)me.name = “form1“me.text = “动态创建 sql server 数据库、表、存储过程等架构信息“ctype(me.datagrid1, ponentmodel.isupportinitialize).endinit()me.resumelayout(false)end sub#end region创建数据库private sub createdbbtn_click(byval sender as system.object, byval e as system.eventargs) _handles createdbbtn.clickconn = new sqlco
