我用的是adodc1 和datagird 控件绑定,adodc1使用连接字符串连接数据库,并且和表绑定,datagird控件则绑在adodc1上,设置datagird的相应属性后,运行后,ADODC的滚动剪头是灰色的,而且datagird 控件里什么都没显示,这是怎么回事?Private Sub Adodc1_DragDrop(Source As Control, x As Single, y As Single)
Adodc1.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=book_manage;Data Source=VIN " Adodc1.ConnectionTimeout = 15 Adodc1.CommandTimeout = 30 Adodc1.CommandType = adCmdText Adodc1.RecordSource = "mySQL_select * from department1" Adodc1.RefreshEnd Sub
Adodc1.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=book_manage;Data Source=VIN " Adodc1.ConnectionTimeout = 15 Adodc1.CommandTimeout = 30 Adodc1.CommandType = adCmdText Adodc1.RecordSource = "mySQL_select * from department1" Adodc1.RefreshEnd Sub
解决方案 »
- 怎样在一副图中快速查找另一幅图?
- VB连接远程数据库SQL SERVER 连接不上
- App.path怎么用?
- 怎么样做网页ASP数字签名
- [求助]各位大虾有关VB与SQL的问题~~~~
- 简单问题用*画园
- 一个自己不能解决的错误!!!
- 我信箱里经常收到“CSDN邮件期刊”,可不知道怎么阅读,
- 关于MSFlexGrid控件合并单元格的问题
- vb中的timer倥件的问题。
- 我用VB6编程,用Inet1.OpenURL下载网页http://www.btophr.com/forum/messanger_ma.asp?action=inbox,可总是下载到的是http://www.btophr
- dtpicker 日期显示控件
怎么才能出现像图中那样可以有黑色箭头的ado啊
Adodc1.ConnectionString = "Provider=SQLOLEDB.1;Password=sa;Persist Security Info=True;User ID=sa;Initial Catalog=U8COST;Data Source=localhost" Adodc1.ConnectionTimeout = 15 Adodc1.CommandTimeout = 30 Adodc1.CommandType = adCmdText Adodc1.RecordSource = "select * from Tinput_M" Adodc1.Refresh
Set DataGrid1.DataSource = Adodc1.Recordset
End Sub
Adodc1.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=book_manage;Data Source=VIN "Initial Catalog=book_manage; '你机器上有这个数据库吗?
Data Source=VIN '你可以连接到VIN这台服务器吗?
Adodc1.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=book_manage;Data Source=VIN" Adodc1.ConnectionTimeout = 15 Adodc1.CommandTimeout = 30 Adodc1.CommandType = adCmdText Adodc1.RecordSource = "select * from department1" Adodc1.Refresh
Set DataGrid1.DataSource = Adodc1.Recordset
End Sub
但,在程序记动时并没有指定数据源,因为你只指定了DATAMEMBER,而没指定ADODB1的RECORDSOURCE,所以程序会报错。实际使用中,绝大多数时间为了编程的灵活性,需要使用运行时来设置,而不要在设计时设置。Ok?