Help with datagrid and query

[Notorios]

I have a data projct doing and have a couple queries, I simply need to know how i get the datagrid to show the results from my query can someone tell me how i do that.

I looked over my post noticed i had flexgrid, please people i need help with this i just need to know how to populate my datagrid with the results from my sql select query

please and thank you

[Notorios]

No one at all can help me with this, im dying here and really need some help, very important

[ramesh]

What connector are you using to connect to your data, DataEnvironment? If so, make sure the DE has a command set up for the SQL query. Then click the datagrid to bring up it's properties. Double-click DATASOURCE to set the source as your DE, then select from the list in DATAMEMBER to choose the appropriate command (query) to display in the grid.

[Bredz]

he's right.... do as stated above

[SQLDBA]

//Declare recordset to hold Query result
Dim myrec as new ADODB.RECORDSET
//Declare an SQL connection

Dim Mycon as new ADODB.connection
Dim constr as String
constr="Provider=Microsoft.Jet.OLEDB.4.0; " & _
"Data Source=C:madhead.mdb""

mycon.connectionstring=constr

myrec.open "select * from customers",mycon,1,2

Lets say your data grid name dglist.
dglist.datasource=myrec

And the dtagrid will show the query result

[ramesh]

I believe he got through. We spent about half an hour on MSN trying to figure out why the DE command would not populate. His query involved using a parameter. A day later, he told me he got through.

[Notorios]

thanx to all you peeps who tried to help me, i got through like ramesh said, bless