Hi all,
I'm new to vb.net and Sql server... So it may be a newbie question, but i've searched many places and did't find the answer.. so, here i go:
I've just installed sql server, and i want to databind some textboxes in a form... but i dont really know how to do this...
For example, i have a table called table1 in my database, like this:
table1
column1(key) column2 column3
1......................a2...........a2
2......................b2...........b3
3......................c2...........c3
but there will be like 20 columns and thousands of rows. I want to make a search and fill the textboxes with the corresponding columns, modify and save in the database again. What is the easiest way to do this? I want to know if there is a asy way to do this, since the project will be constantly modified, new fields may be added. I've been reading, and i think that the best way is to create a dataset and fill with the result of a query to the sql server, but i don't know how to do this... Please, can anyone help me?
Thank you!!
