SQL Database to DataGridView in C#.Net

Question

So far i have done the following...

SqlConnection cnn = new SqlConnection(ConfigurationSettings.AppSettings["strConnection"]);
cnn.Open();
SqlCommand scd = new SqlCommand("select query", cnn);
SqlDataAdapter sda = new SqlDataAdapter(scd);
SqlCommandBuilder scb = new SqlCommandBuilder(sda);
DataSet ds = new DataSet();
sda.Fill(ds);
bindingSource1.DataSource = ds;
dataGridView1.DataSource = bindingSource1;
cnn.Close();

But this code isnt much help to me.it does not display data in datagridview. I want to retrive data from 2 different tables of Database.
Are there any settings i need to do b4 using BindingSource and DataGrid view??
How can i use DataReader for the same.

SAM J · Answer

Thanx Sam. I got the solution. For C#.net 2005 and SQL server 2005 the following code worked. SqlConnection cnn = new SqlConnection(connectionString); SqlCommand scd = new SqlCommand(Sql Query cnn); cnn.Open(); DataTable dt = new DataTable(); SqlDataAdapter sda = new SqlDataAdapter(scd); sda.Fill(dt); DataView dv = new DataView(dt); dataGridView1.DataSource = dv; This code populates the datagridview control with the query result.

Sam Hobbs · Answer

Thank you Sandy. Did you look at my article? Have you looked at other articles in this web site?

SAM J · Answer

My problem is not with the joins. I cant get the data into the datagrid from the SQL database though my C#.net code that i have given.

Sam Hobbs · Answer

Do you need to update the table(s) or just show the data? If you need to show data from two tables then that is nearly always done using a join; are you familiar with joining tables? There are many useful articles in this web site. My Database Table Update in a DataGridView without Writing Code might help but there are many others. Note that for most of them you need to understand about joining tables and when you do understand that most of the artilces about reading one table can be used for two tables that are joined.