problem with datagrid

[rivierem]

hi,

I have a problem with datagrid... i have a textbox ordernumber and i would like to enter the order number of a client and get the details of that client on my datagrid... is this possible... if yes can you please help me???

 

[koen]

Yes its possible...

for instance:
--when clicked on a button--
make an sql statemant
strSQL = "select * from table where ordernumber = " & cstr(textbox.text)
fill a dataset with that sql statement
fill your datagrid with that dataset

when you have 2 tables maybe you can use databinding...

greets koen

 

[rivierem]

hi KOEN,

Thanks for your help, ill try what you suggested... i hope it will work...

 

[rivierem]

a little more help...

Hi, if you could please explain more in detail, im kind of a beginner in visual basic 6.0

 

[rivierem]

a little little more help...

Hi,

how do you fill a dataset with sql and how do you fill datagrid with dataset????

thanks in advance

rivierem

 

[Arch4ngel]

Look in the Data section of your toolbar.

OleDbAdapter is an adapter to MS Access, SQL-Server (and some more).
It will fill your DataSet (which contain DataTable).

I suggest you take a good tutorial on it.
Its not an easy thing to understand when you begin.

 

[Iceplug]

Hi, if you could please explain more in detail, im kind of a beginner in visual basic 6.0

If you are using VB 6, you need to go here to our sister site:
http://www.computerhelp.forum/