Reading multiple tables from database through datareader

[dotnetnovice]

Hi dear fellows...i am a newbie in C# and practicing it hardly to learn it.

Actually i am reading a table from data base through data reader and displaying it in the gridview and i am doing well the problem i want to read and display 2 tables at a time in the same grid view.

Here is my Code in the class DBHandler.

public class DBHandler
{
 
private const String ConnectionString = @"initial catalog=FinalProjectDB;Data Source=ALIEN\SQLEXPRESS;integrated Security=true;";
 
public List<Programs> GetAllPrograms()//Programs is the class name
 
{
 
SqlConnection con = new SqlConnection(ConnectionString);
SqlCommand com = new SqlCommand();
com.CommandType = System.Data.CommandType.Text;
com.CommandText = "SELECT * FROM Programs";
com.Connection = con;
 
List<Programs> Program = new List<Programs>();//Programs is the class name
 
SqlDataReader reader;
 
con.Open();
 
reader = com.ExecuteReader();
 
if (reader.HasRows)
{
while (reader.Read())
{
Programs P = new Programs();//Object Created from class Programs
 
P.Id = Convert.ToInt32(reader["ProgramID"]);//Reading the contents of Table in database using datareader and assigning them to class programs object
P.Title = reader["Title"].ToString();
P.Instructor = reader["Instructor"].ToString();
 
Program.Add(P);
}
 
}
 
con.Close();
 
return Program;
 
}

I am using a class DB handler to read data from Data base.

And the code in my form is.

private void Form1_Load(object sender, EventArgs e)
{
 
DBHandler ObjDBHandler = new DBHandler();
 
//dataGridView3.AutoGenerateColumns = false;
 
dataGridView3.DataSource = ObjDBHandler.GetAllPrograms();
 
}

There are total two class are involved one is DBHandler Which i explained above and another class Programs having information like ID, Title etc of the study programs

Please help me as soon as possible.

Thankyou.

}

[fastestindian]

Are these tables related to each other?
Gridview can show values from Dataset. So if values are related then using JOIN's can show the table to the Grid View.