Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

Row Number

Comment:

I want to Coloum namely Record No. in my databse program VB6. This number I want to retreive from the table I created for the Program. The Number would be Row Number where the data has been stored. How do I do it programatically. Himadri

Name: Chi Happens
Date: February 24, 2005 at 05:04:00 Pacific

Reply:

huh wah? you want to retrieve a field from your db called RecordNumber? Dim CN as ADODB.Connection Dim RS as ADODB.RecordSet Set CN = new ADODB.Connection CN.Open [PUT YOUR CONNECTION STRING HERE] Set RS = new ADODB.RecordSet RS.Open "SELECT RecordNumber FROM [PUT YOUR TABLE NAME HERE]", CN While not RS.EOF     ' do something with the value     Debug.Print RS("RecordNumber")     RS.MoveNext loop RS.Close CN.Close Set RS = nothing Set CN = nothing Hope this helps, Chi They mostly come at night...mostly

0

pointer to byte array

Locate binary data in arr...

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: Haven't seen much VB around here but I'll take a shot. I have a datagridview and I have it set up so you can only select whole rows. I need to get the index number of the currently selected row. I can...

Summary: ok i know there is a lot of people trying to get answers for free, but i am truly stuck with my code.... here is what i have: // This program calculates the mean, median and mode for two separate fil...

Summary: I am trying to query database: there 1000 records and i need row number 120th. How do i write a quesry for this. I hope someone will help me out. Atif ...