Loading 2 or more Tables Into a single DataSet using VB.NET and SQL server

Question

0.00/5 (No votes)

See more:

Thanx guys for the help But now for application I need load more than 2 tables into a single DataSet but please do bare in mind that I am NOT YET Familiar with stored procedures in SQL Server 2008 the code that I am using is as shown below.Please guyz do help me I am still new to VB.NET

Imports System
Imports System.Drawing
Imports System.Collections
Imports System.ComponentModel
Imports System.Windows.Forms
Imports System.Data
Imports System.Data.SqlClient
Public Class Form1
    Public Sub New()
        InitializeComponent()
        ' connect to my local server, northwind db
        Dim connectionString As String = _
            "server=localhost; " & _
            "Integrated Security=True; " & _
            "database=Northwind"

        Dim commandString As String = _
        "Select CompanyName, ContactName, ContactTitle, " & _
        "Phone, Fax from Customers"

        ' create a data set and fill it
        Dim myDataAdapter As _
        New SqlDataAdapter(commandString, connectionString)
        Dim myDataSet As New DataSet()
        myDataAdapter.Fill(myDataSet, "Customers")

        ' bind the DataSet to the grid
        CustomerDataGrid.DataSource = _
            myDataSet.Tables("Customers").DefaultView
    End Sub 'New

Posted 20-Jul-11 2:07am

sijimann

Updated 20-Jul-11 2:08am

Toniyo Jackson

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Toniyo Jackson · Accepted Answer · 2011-07-20T02:13:00

Solution 1

Write another query by separating with ;

Dim commandString As String = _
        "Select CompanyName, ContactName, ContactTitle, " & _
        "Phone, Fax from Customers; " & _
        " Select * from tablename"

Try to use Stored Procedure[^] always.
Check this link for more info.

http://www.sql-server-performance.com/2003/stored-procedures-basics/[^]

Posted 20-Jul-11 2:13am

Toniyo Jackson

Updated 20-Jul-11 2:14am

v2

Comments

sijimann 20-Jul-11 8:31am

Thanx a lot how do I get to fill the dataset do I fill like this

myDataAdapter.Fill(myDataSet, "Customers"&"Other TableName")

Toniyo Jackson 20-Jul-11 8:36am

Just use myDataAdapter.Fill(myDataSet)

sijimann 20-Jul-11 8:49am

Thanx a lot you are a star

Toniyo Jackson 20-Jul-11 8:52am

You are Welcome :)

[no name] 20-Jul-11 11:55am

Excellent.+5.

Toniyo Jackson 21-Jul-11 1:46am

Thanks Ram :)

#realJSOP · Accepted Answer · 2011-07-20T02:18:00

Just because you're coding it in VB doesn't mean you're free from having to be familiar with SQL. Afterall, your command string is SQL. Regardless of whether or not you're writing a stored proc, you still have to know how to write your query. I personally think it's easier to use SQLServer Manager Express to write a query because you can test it without having to continually stop to edit code and compile your app.

In the end, I suspect you want to perform multiple queries and have the returned tables put into your dataset. I found this with a simple google search for "c# multiple tables in dataset":

Multiple Tables in Dataset[^]