Member Avatar for fabiocrj

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!!

Edited by fabiocrj because: just formatting the table
  • 1 Contributor
  • 1 Reply
  • 276 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by fabiocrj
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.