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相关联

我该怎么做啊

select s.t_specialtyID,s.t_specialtyName,s.t_Year,n.T_name,s.t_caption from tb_SpecialtyInfo as s,另一张表 as n where  s.t_specialtyID = n.t_CollegeID

收到的鲜花

• maibarry 于 2008-11-10 13:16 送鲜花  5朵   附言：我很赞同

好要把列名也改了呢

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

学习一下！！