پر کردن data grid با ستون هایی از چند جدول

[hossin.esm]

DataSet ds = newDataSet();

SqlDataAdapter da = newSqlDataAdapter();

SqlConnection con = newSqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirecto  ry|\\File.mdf;Integrated Security=True;Connect Timeout=30");

SqlCommand cmd = newSqlCommand();

ds.Clear();

da.SelectCommand = newSqlCommand();

da.SelectCommand.CommandText = "select table1.name as ,table2.family as ,table3.text as from table1,table2,table3";

da.SelectCommand.Connection = con;

con.Open();

da.Fill(ds, "view");

con.Close();

dataGridView1.DataSource = ds;

dataGridView1.DataMember = "view";