We help IT Professionals succeed at work.

Need starting place for VB linq to sql+datasets

I'm looking for is a good VB tutorial how to do these things or an example that can explain each part of why it was done the way it was done.

I'm new to programming and all the sites I find show me how to do select, insert, update, delete using LINQ. My problem isn't so much doing these task as it is how to get these individual row/columns to use controls like text boxes. I know hot to pull from text boxes and into the SQL database, but I don't know how to pull from SQL databse to put info into text boxes I can only do datagridview.
I know the very basic of using datasets, but I don't want to have to type a long SQL select statement then trying to figure out whats wrong with it (The purpose of LINQ I believe) to fill these datasets.

Sorta side question I know its kinda vague but Overall is it easier to write a  complete interface to a databases UI going to use just LINQ to SQL, Datasets, or a combination of LINQ + Datasets?
Watch Question

Most Valuable Expert 2012
Top Expert 2014
Not sure I fully understand you questions. In a production project that I did sometime ago, I used a combination of LINQ and Datasets. I used LINQ2SQL for creating, retrieving, updating, and deleting objects. I used datasets with stored procedures for listing objects for performance reasons. I said objects because in LINQ its objects not rows.


I do not know how to really word my question, because I don't know enough to really ask. I'm trying to find a starting point that explains to me how I can pull from a database using LINQ with controls like text boxes.

For example I have just a dataset not using LINQ, but I would like to figure out how to use LINQ in this code, because I can take things from a dataset and put it into a text box.
'ds is the dataset, firstdb is my database, inc changes which row you have selected.
txtInvoiceNumber.Text = ds.Tables("Firstdb").Rows(inc).Item("InvoiceNumber")

Open in new window

Dim query = (From invo In database.Invoices
                    Select invo).ToString

just looking over the datasets examples and figuring out how to change the LINQ code to work with it...


Guess I just need to do some reading to become more versed on the subject before asking questions.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.