databasegrid

[matjev]

Hello folks

Where can I find a database Grid?

Which reference or component do i have to include?

[Buzby]

In PROJECT/COMPONENTS;

Microsoft DataGrid Control 6.0 (MSDATGRD.OCX)
Microsoft FlexGrid Control 6.0 (MSFLXGRD.OCX)

Or don't use the (rubbish) Microsoft grids and get TrueDBGrid from www.componentone.com

[matjev]

is there no place where i can find grids for free?

[Buzby]

Well the datagrid and flexgrid shipped with VB are free, but as they say 'you get what you pay for'. Yes, they'll probably do what you want to start off with, but when you get into more complicated programs you'll soon find out how rubbish they are. You can go to www.componentsource.com and search for grid controls there - some may be cheaper than the *FANTASTIC* TrueDBGrid, but you'll be hard pressed to find one with more features than it.

[matjev]

but i don't want a datagrid
is there nothing like a databasegrid

[Beacon]

What are you trying to do???

[matjev]

I'm trying to put an sql into a grid
but the sql is a combination of 2 tables....

And there must be a method in the grid to update, delete and modify records

[Beacon]

What do you mean an sql??

Do you mean:
1) Display the data in a grid from a sql database. Add and make changes etc.
Or
2) Display the sql database! SHowing the 2 tables and there structure!

If it's number 1 i have told you what you need to do and dbgrid is perfect for this!
It can update, delete and modify records!

[Beacon]

I'm going now. PM me if you need more advice/help!

[matjev]

displaying data form 2 tables in a grid

[Beacon]

Do you know how to connect to the db in visual basic?

I.e dao and ado?

If not you'll need to read the tutorials to get a grip of it!

DBgrid or flexigrid will do you fine!

You have to connect visual basic project to the db. You cant just set the datasource of the grid to the sql database.
To do this you use ado or dao or the data controls!

Then you'll need to set up some recordsets and use SQL statements to get the data you want!

Set the datasource of the grid to your datacontrol or connection string.

good luck