我将连接的信息,写到ini文件了。
Adodc1.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=" & Gs_Database & ";Data Source=" & Gs_Server
Adodc1.CommandType = adCmdUnknown
DataGrid1.AllowAddNew = True
DataGrid1.AllowDelete = True
DataGrid1.AllowUpdate = True
Select Case dmwhtbl
Case "pjsdm"
frmdmwh.Caption = "警示代码维护"
Adodc1.RecordSource = "select jsdm,jsmc from pjsdm"
Adodc1.Refresh
If Adodc1.RecordSet.RecordCount = 0 Then '没有记录
Adodc1.RecordSet.AddNew
End If
DataGrid1.ReBind
DataGrid1.RowHeight = 300
DataGrid1.ColumnHeaders = True
DataGrid1.Columns(0).Caption = "代码(jsdm)"
DataGrid1.Columns(1).Caption = "名称(jsmc)"
DataGrid1.Columns(0).DataField = "jsdm"
DataGrid1.Columns(1).DataField = "jsmc"
DataGrid1.Columns(0).Width = 1400
DataGrid1.Columns(1).Width = 3600
Case "giscssz"
End Select
DataGrid1.Refresh多谢各位!:)
Adodc1.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=" & Gs_Database & ";Data Source=" & Gs_Server
Adodc1.CommandType = adCmdUnknown
DataGrid1.AllowAddNew = True
DataGrid1.AllowDelete = True
DataGrid1.AllowUpdate = True
Select Case dmwhtbl
Case "pjsdm"
frmdmwh.Caption = "警示代码维护"
Adodc1.RecordSource = "select jsdm,jsmc from pjsdm"
Adodc1.Refresh
If Adodc1.RecordSet.RecordCount = 0 Then '没有记录
Adodc1.RecordSet.AddNew
End If
DataGrid1.ReBind
DataGrid1.RowHeight = 300
DataGrid1.ColumnHeaders = True
DataGrid1.Columns(0).Caption = "代码(jsdm)"
DataGrid1.Columns(1).Caption = "名称(jsmc)"
DataGrid1.Columns(0).DataField = "jsdm"
DataGrid1.Columns(1).DataField = "jsmc"
DataGrid1.Columns(0).Width = 1400
DataGrid1.Columns(1).Width = 3600
Case "giscssz"
End Select
DataGrid1.Refresh多谢各位!:)
解决方案 »
- 在VB中报表按条件进行打印的一些问题的请教?
- 如何得到,当天农历
- 欲查询数据库中某一字段是否包含一个字符串变量中的所有单个字符(在字段中字符顺序和变量中字符顺序相同,但各字符不一定相邻)
- 請問如何不關閉程序而只是隱藏,而當用戶再次打開時則最大化顯示
- 请问一下在mediaplayer中怎么实现左右声道,和音量条控制音量大小??在线等!~
- 迎新年,送福帖!看谁先到2011
- [求助] 超级兔子是怎样备份注册表的?
- 请教专家,如何实现数组的快速复制?
- 请问如何判断一个文件夹是否存在(不能用文件对象)100分
- 怎么获得鼠标的窗体位置和在桌面上的位置!
- ☆★★☆如何屏蔽 MSHFlexGrid 的键盘消息,如left,right,home,end等健
- 请问怎样将access数据库打包进去?
Adodc1.CommandType = adCmdUnknown DataGrid1.AllowAddNew = True
DataGrid1.AllowDelete = True
DataGrid1.AllowUpdate = True
Select Case dmwhtbl
Case "pjsdm"
frmdmwh.Caption = "警示代码维护"
Adodc1.RecordSource = "select jsdm,jsmc from pjsdm"
Adodc1.Refresh
If Adodc1.RecordSet.RecordCount = 0 Then '没有记录
Adodc1.RecordSet.AddNew
End If
DataGrid1.ReBind
DataGrid1.RowHeight = 300
DataGrid1.ColumnHeaders = True
DataGrid1.Columns(0).Caption = "代码(jsdm)"
DataGrid1.Columns(1).Caption = "名称(jsmc)"
DataGrid1.Columns(0).DataField = "jsdm"
DataGrid1.Columns(1).DataField = "jsmc"
DataGrid1.Columns(0).Width = 1400
DataGrid1.Columns(1).Width = 3600
Case "giscssz"
.....
End Select
DataGrid1.Refresh多谢各位!!
尤其感谢cuiyxy(沧海鲨鱼)!