•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Visual Basic 4 / 5 / 6 section within the Software Development category of DaniWeb, a massive community of 391,944 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,901 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Visual Basic 4 / 5 / 6 advertiser:
Views: 130 | Replies: 1
 |
•
•
Join Date: Jul 2008
Posts: 2
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
I am using this query
sql="select * from student"
if rs.state=1 then rs.close
rs.open sql,strcon,3,3
while not rs.eof
datagrid1.datasource=sql
datagrid1.refresh
wend
where as rs is a recordset variable and strcon defines the connection to the data base.
please guide me for correction
sql="select * from student"
if rs.state=1 then rs.close
rs.open sql,strcon,3,3
while not rs.eof
datagrid1.datasource=sql
datagrid1.refresh
wend
where as rs is a recordset variable and strcon defines the connection to the data base.
please guide me for correction
•
•
Join Date: Jun 2007
Posts: 76
Reputation:
Rep Power: 2
Solved Threads: 6
Junior Poster in Training
HI,
you can try the coding, this could helpful to u.
Shailaja
you can try the coding, this could helpful to u.
sql="select * from student" if rs.state=1 then rs.close rs.CursorLocation = adUseClient rs.open sql,strcon,3,3 Set DataGrid1.DataSource = rs DataGrid1.Refresh
Shailaja
•
•
•
•
Originally Posted by electrosoul456 
I am using this query
sql="select * from student"
if rs.state=1 then rs.close
rs.open sql,strcon,3,3
while not rs.eof
datagrid1.datasource=sql
datagrid1.refresh
wend
where as rs is a recordset variable and strcon defines the connection to the data base.
please guide me for correction
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb Visual Basic 4 / 5 / 6 Marketplace
Linear Mode
•
•
•
•
access advice broadband business code coding combo competition compilers computer daniweb data data protection data transfer database developer developers development drive dropdownlist encryption errors europe forensic forensics google hacking hard hardware help hitachi hp industrial espionage internet languages module net news power privacy programming protection reuse sans search security storage terabyte web wikipedia
- Previous Thread: loop
- Next Thread: Shelled Process
