What is the code for displaying records in a datagrid?

danfreak11

How can I display my database records in a datagrid?

Can someone help me with these. Im a beginner in vb6

missinglinq

Since this is a question about VB 6, I'll move it to the Visual Basic Forum.

Welcome to Bytes!

Linq ;0)>

Moderator

lotus18

There are a lot of ways on how to display records in a datagrid. We have ADODB, ADODC etc.

Rey Sean

QVeen72

Hi,

Open a Connection Object...
and add a DataGrid Control on your form:
Write this code in Form_Load:

Expand|Select|Wrap|Line Numbers

 
Dim sSQL As String

Dim RST As New ADODB.Recordset

RST.CursorLocation=adUseClient

sSQL = "select * from MyTable"

RST.Open sSQL, con

Set DataGrid1.DataSource = RST

Regards
Veena

What is the code for displaying records in a datagrid?

re: What is the code for displaying records in a datagrid?

re: What is the code for displaying records in a datagrid?

re: What is the code for displaying records in a datagrid?

Similar Visual Basic 4 / 5 / 6 bytes

/bytes/development

/bytes/it

/bytes/about