datagrid通过List取值

Question

在datagrid的column中的field取另一张表的list集合里面的值，我应该怎么写呢

Answer 1

SqlConnection conn = new SqlConnection("Data Source=.;User ID=sa;Password=sa;Initial Catalog=Test;");
string sql = "select * from Table1";
SqlDataAdapter da = new SqlDataAdapter(sql, conn);
da.Fill(ds);
dataGrid.DataSource = ds.Tables[0];
conn.Close();