Programming Forums
User Name Password Register
 

RSS Feed
FORUM INDEX | TODAY'S POSTS | UNANSWERED THREADS | ADVANCED SEARCH

Reply
 
Thread Tools Display Modes
Old Dec 22nd, 2005, 9:59 AM   #1
fox123
Newbie
 
Join Date: Mar 2005
Posts: 25
Rep Power: 0 fox123 is on a distinguished road
Data Control

I am not sure if the soloution to my problem is simple, but all i want to do is make the data control display a record number generated by the VB rnd function. I can code the rnd bit but dont know how to display the record
Thanks
fox123 is offline   Reply With Quote
Old Dec 22nd, 2005, 9:49 PM   #2
Rory
Expert Programmer
 
Rory's Avatar
 
Join Date: Jan 2005
Location: London
Posts: 542
Rep Power: 4 Rory is on a distinguished road
Send a message via MSN to Rory
Because ADO is crap, or rather is one of the old DB APIs that abstract out everything from drivers, it can only make relative movement through a recordset so you cannot specify an absolute position without running a query. Either "SELECT * FROM SOMEWHERE WHERE ID = '" & cstr(Fix(rnd)) & "'" or if you don't have arbitrary tuples:

DB.MoveFirst
DB.Move CLng(Fix(rnd))

ADO is out of date and was never any good anyway IMO.
Rory is offline   Reply With Quote
Old Feb 4th, 2006, 3:24 AM   #3
exreme_yow
Newbie
 
Join Date: Feb 2006
Posts: 1
Rep Power: 0 exreme_yow is on a distinguished road
I'm trying working with my database project using MS Excel. The records in
datagird connected to MS Excel is working and i used add some codes in order to add data in the data grid and it works. My problem is how would I delete
a record in the data grid? Coz I used to provide one but my PC hung every time
I test my Delete button.


Any idea or source codes for this?




Thanks
__________________
Extreme Yow...


Web Design
Australian used cars
exreme_yow is offline   Reply With Quote
Reply

Bookmarks

« Previous Thread in Forum | Next Thread in Forum »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump




DaniWeb IT Discussion Community
All times are GMT -5. The time now is 7:30 AM.

Powered by vBulletin® Version 3.7.0, Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Copyright ©2007 DaniWeb® LLC