欢迎来到天天文库
浏览记录
ID:32928643
大小:49.00 KB
页数:8页
时间:2019-02-17
《怎么用asp创建sql数据表相关操作》由会员上传分享,免费在线阅读,更多相关内容在教育资源-天天文库。
1、.下面是利用sql语句创建数据库、表、存储过程、视图、索引、规则、修改表、查看数据等的方法。所要增加的控件如下:importssystem.dataimportssystem.data.sqlclientpublicclassform1 inheritssystem.windows.forms.form privateconnectionstringasstring="datasource=.;initialcatalog=;userid=sa;password=;" privatereaderassql
2、datareader=nothing privateconnassqlconnection=nothing privatecmdassqlcommand=nothing privatealtertablebtnassystem.windows.forms.button privatesqlasstring=nothing privatecreateothersbtnassystem.windows.forms.button#region"windows窗体设计器生成的代码" 窗体重写处置以清理组件列表。
3、protectedoverloadsoverridessubdispose(byvaldisposingasboolean) ifdisposingthen ifnot(componentsisnothing)then components.dispose() endif endif mybase.dispose(disposing) endsub publicsubnew() mybase.new() initializecomponent() endsu
4、b privatecomponentsassystem.componentmodel.icontainer friendwitheventsdatagrid1assystem.windows.forms.datagrid friendwitheventscreatedbbtnassystem.windows.forms.button friendwitheventscreatetablebtnassystem.windows.forms.button friendwitheventscreatespbtn
5、assystem.windows.forms.button friendwitheventscreateviewbtnassystem.windows.forms.button friendwitheventsbtnaltertableassystem.windows.forms.button friendwitheventsbtncreateothersassystem.windows.forms.button friendwitheventsbtndroptableassystem.windows.f
6、orms.button friendwitheventsbtnviewdataassystem.windows.forms.button friendwitheventsbtnviewspassystem.windows.forms.button friendwitheventsbtnviewviewas...system.windows.forms.button privatesubinitializecomponent
7、() 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.butt
8、on() 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.bt
此文档下载收益归作者所有