已经把我的程序贴了出来,请给出提示,谢谢
以下是引用purana在2007-1-3 14:37:10的发言:
"Provider=SQLOLEDB;Data Source=服务器名或IP地址;Initial Catalog=数据库名;User ID=用户名;Password=密码"
单纯的这样写好像不行
1、我用ADO向导做了连接,是在主窗体上添加了Adodc,然后再ADODC Properties -> Use Connection String 看到了语句Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=cmdata;Data Source=localhost,但如果我不用ADODC的话,怎么才能把 这条句子正确的写出来,或者我应该双击DataGrid之后再这里写呢?
Private Sub DataGrid_Click()
Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=cmdata;Data Source=CCWDL
End Sub
但这样写不对啊,请版主和各位大侠指点
2、这句还是错误的,怎么回事啊?郁闷!
Private Sub DataGrid_Click()
Adodc1.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=cmdata;Data Source=localhost;"
Adodc1.Open
Adodc1.RecordSource = "select * from t_Customer"
Adodc1.Refresh
End Sub
[此贴子已经被作者于2007-1-3 17:32:57编辑过]