how to get data from 3 different tables in sql.

 

DataSet ds = new 
DataSet(); 

SqlDataAdapter adapter = new SqlDataAdapter(cmd ); 
adapter.Fill(ds); 

DataTable dt = ds.Tables[0];//dt contains your dataset. 


if (dt == null)

   MessageBox.Show("Data set is null");

 

private void button1_Click(object sender, EventArgs e)

{

int id = Convert.ToInt32(comboBox1.SelectedValue);

//Now you are going to pass the ID to 
stored procedure. Here, I assume the you are using SQL Server as your 
DB.

SqlConnection sqlConn = null;

try

{

sqlConn = new 
SqlConnection(CONNECTION_STRING);//connction 
string for your DB

sqlConn.Open();

SqlCommand sqlCommand = new SqlCommand("mysp", 
sqlConn);// mysp is the name of the stored 
procedure.

sqlCommand.CommandType = CommandType.StoredProcedure;

sqlCommand.Parameters.Add(new SqlParameter("@id", id));

DataSet ds = 
new DataSet();

SqlDataAdapter adapter = new SqlDataAdapter(sqlCommand);

adapter.Fill(ds);

DataTable dt = 
ds.Tables[0];//dt contains your 
dataset.

}

catch (Exception ex)

{

//Error

}

}

 

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

go

 

 

CREATE PROCEDURE [YOUR_SCHEMA].[mysp] 



@id INT 


AS

BEGIN

SELECT * 

FROM ffff 
a,


qqqq  b,

rrrr c 

WHERE a.column001 = b.column001

AND a.column001= c.column001

AND  b.column001 
= c.column001

END