How can we load multiple tables in a Dataset

Question

Hi, How can we load multiple tables in a Dataset?

Satyapriya Nayak · Answer

Hi eddie, Normal 0 Imports System.Data.SqlClient Public Class Form1 Inherits System.Windows.Forms.Form Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click con.Open() str = "select * from student;select * from customer;select * from product" com = New SqlCommand(str, con) sqlda = New SqlDataAdapter(com) ds = New DataSet sqlda.SelectCommand.CommandText = str sqlda.Fill(ds) DataGrid1.DataSource = ds End Sub End Class

Mayur Dighe · Answer

This Articles will helpful to you... http://www.vbdotnetheaven.com/UploadFile/ea36c5/5812

Eddie Jack · Answer

Thanks, mayur Dighe

Mayur Dighe · Answer

we can not write Sql Query like this ..... it is of no use... if you want to take All Data From 3 Different Tables you must load them individual into dataset using adaptor. i think in each of table (Student, Customer, Product) have a Primary Key then you can assign a common name to it e.g. 1.select StudId AS ID form Student 2.select CustID as ID from Customer etc.. after loading each table(supposed named as 'Information') into dataset you will get single column of ID into DataTable and not 3 separate columns for separate tables... You CAN achieve the intended result doing like this..... Read More about.. Transaction-SQL especailly Select Clause