string str_select = "select 专业ID=t_specialtyID,专业名=t_specialtyName,学习年制=t_Year,院系名=t_CollegeID,说明=t_caption from tb_SpecialtyInfo";
string connString = ConfigurationManager.ConnectionStrings["connString"].ConnectionString;
SqlConnection conn = new SqlConnection(connString);
DataSet ds = new DataSet();
SqlDataAdapter da,da2;
da = new SqlDataAdapter(str_select ,conn);
da.Fill(ds, "tb_SpecialtyInfo");
this.dGridV_specialty.DataMember = "tb_SpecialtyInfo";      //绑定dGridV_specialty控件
MyBm = this.dGridV_specialty.BindingContext[ds, "tb_SpecialtyInfo"];


我想院系名哪一项显示另一个表中的T_name项，tb_SpecialtyInfo和另一个表的t_CollegeID相关联

我该怎么做啊

好要把列名也改了呢

还不和我要的和，
s.t_specialtyID这一列应该显示另一个表中的t_name列的值