Line 17: ///Gallery
Line 18: StringBuilder sb1 = new StringBuilder();
Line 19: SqlDataAdapter da1 = new SqlDataAdapter("select convert(nvarchar,b.renDate,106) as 'DATE', a.materialTitle as 'TITLE', b.category as 'TYPE', (case when b.fileType='Link' then b.fileName else 'Gallery/'+b.fileName end) as 'DOWNLOAD', a.autoId as 'AUTOID' from tblGalleryDTSKSMWeb a,tblGalleryuploadphotoDTSKSMWeb b where b.gallerytitleId="+Request.QueryString["autoId"].ToString().Trim()+" and a.autoid=b.gallerytitleid and a.astatus='OK' and b.status='OK' order by b.renDate desc, b.autoid desc", con);
Line 20: DataSet ds1 = new DataSet();
Line 21: da1.Fill(ds1, "tblll");
|