807
社区成员
发帖
与我相关
我的任务
分享参数查询怎样写?
设计报表
用datareporter连接dataenvironment
请问在dataenvironment的SQL命令中如何写参数查询?
比如我要用户输入一个姓名来进行查询,
用datareporter连接dataenvironment
请问在dataenvironment的SQL命令中如何写参数查询?
比如我要用户输入一个姓名来进行查询,
...全文
请发表友善的回复…
发表回复
haipingma 2003-09-20
- 打赏
- 举报
動態設定妳的SQL指令:
DataEnvironment1.Connection1.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=databasename;Data Source=servername"
DataEnvironment1.Commands("command1").CommandText = "select * from tablename where username='" & trim(text1.text) & "'"
DataEnvironment1.Connection1.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=databasename;Data Source=servername"
DataEnvironment1.Commands("command1").CommandText = "select * from tablename where username='" & trim(text1.text) & "'"
