May anyone explain me how to use DBGrid in VB6.0 ?

[sreekandan]

Now I have to use DBGrid to edit and retrieve from the database.
So how can I do that in VB6.0?.So kindly reply me anyone quickly.

[vijaydiwakar]

Now I have to use DBGrid to edit and retrieve from the database.
So how can I do that in VB6.0?.So kindly reply me anyone quickly.

Private Sub Command1_Click()

rs0.opend "select * from table ", Conn
db.DataSource = rs0
End Sub

in this way u can retrive the data

[sreekandan]

Private Sub Command1_Click()

rs0.opend "select * from table ", Conn
db.DataSource = rs0
End Sub

in this way u can retrive the data

I couldn't access with that code. So I want the codings with some more details.

[vijaydiwakar]

I couldn't access with that code. So I want the codings with some more details.

explain me thy reqd in detail

[sreekandan]

explain me thy reqd in detail

I want to retrieve the database fields in DBGrid .
My database table is table1,The fields are empid,dat....
For that kidly send me the codings to show/edit the databse contents in DBGrid1.

[vijaydiwakar]

I want to retrieve the database fields in DBGrid .
My database table is table1,The fields are empid,dat....
For that kidly send me the codings to show/edit the databse contents in DBGrid1.

 
dim Rs0 as new Adodb.Recordset
dim Conn as new Adodb.Connection
Conn.open " Connection String"
ssql="select * from table1"
rs0.open ssql,Conn
with grd

do while rs0.eof=false
.rows=.rows+1
.textmatrix(.rows,1)=rs0("fiildname") &""
.textmatrix(.rows,2)=rs0("fiildname") &""
rs0.movenext
loop
rs0.close:set rs0=nothing
end with

in this way u can retrive d data

[sreekandan]

 
dim Rs0 as new Adodb.Recordset
dim Conn as new Adodb.Connection
Conn.open " Connection String"
ssql="select * from table1"
rs0.open ssql,Conn
with grd

do while rs0.eof=false
.rows=.rows+1
.textmatrix(.rows,1)=rs0("fiildname") &""
.textmatrix(.rows,2)=rs0("fiildname") &""
rs0.movenext
loop
rs0.close:set rs0=nothing
end with

in this way u can retrive d data

I tried with that code.But the error occured as "Object required"

[vijaydiwakar]

I tried with that code.But the error occured as "Object required"

for that first of all add control of grid and rename it to the name of grid which ihave given in 'with' code

[sreekandan]

for that first of all add control of grid and rename it to the name of grid which ihave given in 'with' code

Can you explain me the following code from you have given

.rows=.rows+1
.textmatrix(.rows,1)=rs0("fiildname") &""
.textmatrix(.rows,2)=rs0("fiildname") &""

[vijaydiwakar]

Can you explain me the following code from you have given

.rows=.rows+1
.textmatrix(.rows,1)=rs0("fiildname") &""
.textmatrix(.rows,2)=rs0("fiildname") &""

line 1 increments grid row by one
2 assigns recordset's field data to perticular cell with last newest row and 1,2 column