Search Option

[pame1la]

i am trying to create a search option, the user inputs the product name and i want to performa search to return two tables in the dbase. This is all okay.

when displaying the found data, come will be in textboxes, comboboxes and also a datagrid. Do i need to assign each column individually eg:


txt1.Text = Product Details.Lname
combo1.Text = ProductDetails.Town

and in the datagrid
datagrid.column(0) = ProductDetails.Salary

can i do it lik this? is there a similar way to do it???

[penagate]

Dunno much about DataGrids, but if you assign it to a table don't the columns come up automatically?

[pame1la]

with the storage mode u assign the grid to an array.. i have created the columns for the grid manually, not assigned it directly to any table..... cos i thought i wod have to edit names anyway!

[penagate]

OK, I'm really out of my depth here but just an idea, can you iterate through the table's fields and assign each to a column index?

[pame1la]

yeah dats wot i thought of, was just wondering if there was a easier way to be honest, il try it and let u no