select *,RANK() over (order by il_id) as shu into #hotmp from (select il_id,il_userid,il_url,il_description,il_imageTypeID from tbl_Base_imageLibrary img where il_albumsId in (select albums_Id from tbl_Base_AlbumsInfo where albums_PermissionId=2 and albums_Statue=0) and il_imageTypeID=@Typeid union all select hil_id,Hil_userid,hil_url,hil_decription,Hil_type from tbl_Base_HotimgLibrary where hil_status=1 and Hil_type=@Typeid )t 这个是采用临时表存储数据的 你改改应该就能用
DataTable dt2=new DataTable();
dt1.Merge(dt2);
dgvOK.Update(); private DataTable GenerateTeacherPlanInfoTable(List<TeacherPlanInfo> lstTPI)
{
DataTable dt = new DataTable("TeacherPlanInfo"); //Create columns and add to DataTable;
DataColumn dcSubject = new DataColumn(Properties.Resources.Subject);
dt.Columns.Add(dcSubject); DataColumn dcPlanDate = new DataColumn(Properties.Resources.PlanDate);
dcPlanDate.DataType = typeof(DateTime);
dt.Columns.Add(dcPlanDate); DataColumn dcIDOfHour = new DataColumn(Properties.Resources.IDOfHour);
dt.Columns.Add(dcIDOfHour); //Now Add some data to the DataTable
DataRow dr; foreach (TeacherPlanInfo item in lstTPI)
{
dr = dt.NewRow();
dr[0] = item.FachAbk;
dr[1] = item.Datum;
dr[2] = item.IDOfHour; dt.Rows.Add(dr);
} return dt;
}
(select il_id,il_userid,il_url,il_description,il_imageTypeID from tbl_Base_imageLibrary
img where il_albumsId in (select albums_Id from tbl_Base_AlbumsInfo where
albums_PermissionId=2 and albums_Statue=0) and il_imageTypeID=@Typeid
union all
select hil_id,Hil_userid,hil_url,hil_decription,Hil_type from
tbl_Base_HotimgLibrary where hil_status=1 and Hil_type=@Typeid
)t
这个是采用临时表存储数据的 你改改应该就能用
DataTable dt2=new DataTable();
dt1.Merge(dt2);
或者用LINQ拼成List集合,这个更方便一些,只是麻烦点