multiple Datalists data showing only on datalist

Phaneendra Chakravaram

Hi here iam using 3 datalists to showing data but i need instead of using 3 datalists i need to use one datalist bcz i need to sort data .if its is one datalist i can sort data.but here three datalists. but query is same in three datalists select command. but here i need to show youtube video and normal local player video and pdf file so i used 3 datalists here i copied my code please give solution.(content type i need to write condition this is only aspx page no c# code in this page so any solution for this)

SelectCommand="SELECT lm.Title, lm.URL, lm.Description from Content as lm where lm.CourseSection=? and lm.ContentType='VideoSVBS'"> //here contenttype videos in svbs(means local video)

Type="Int32" />

CellPadding="0">

<%# Eval("Title")%>

<%# Eval("Description")%>

" style="text-align:center; vertical-align:top; width:100%; margin:10px; padding:10px;padding-left:27px">

CellPadding="0">

<%# Eval("Title")%>

<%# Eval("Description")%>

SelectCommand="SELECT lm.Title, lm.URL, lm.Description from Content as lm where lm.CourseSection=? and lm.ContentType='VideoYouTube'"> //here content type is (video youtube)

Type="Int32" />

CellPadding="0">

" target="_blank" class="PinkLink"><%# Eval("Title")%>

<%# Eval("Description")%>

SelectCommand="SELECT lm.Title, lm.URL, lm.Description from Content as lm where lm.CourseSection=? and lm.ContentType<>'VideoYouTube' and lm.ContentType<>'VideoSVBS'and lm.hide <> true">//(here content type both)

Type="Int32" />

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Phaneendra Chakravaram9y ago
Manas Mohapatra can you help me this solution ..
Phaneendra Chakravaram9y ago
Thank you and one more question i need to show jwplayer video,Youtube video, pdfs hw can i write condition based on content if i ran that query iam gettin proper result but showing in ui
No value given for one or more required parameters.
cz we here 3 (parts(jwplyer,youtube(iframe),pdf) these three how we shown condtion please .
Manas Mohapatra9y ago
Try to change the Select Command text
Select  e.*
from (
    Select  id
    from    Test1
    where   pin=4
    UNION
    Select  id
    from    Test2
    where pin=4
) subSelect Order By subSelect.id;

// OR
SELECT id FROM T1 UNION ALL (SELECT innerTab.id FROM T1 innerTab WHERE innerTab.id = 2) ORDER BY id ASC
If it helps please accept the answer..
Phaneendra Chakravaram9y ago
if it is Sqlserver database i will use sp. but this is msaccess db? how can i write condition manas. i need to write condion in aspx page only select command only? can we check content type (if condition in datalist i dnt have idea about this one) plz give me solution
Manas Mohapatra9y ago
You can use StoredProcedure to call from datasource. SP will combine your results into and retrns back to UI.

In Sp you need to use UnionAll operator like below:
select * from tb1
union all
select * from tb2
union all
select * from tb3
order by id desc;
https://msdn.microsoft.com/en-us/library/8e5545e1(v=vs.100).aspx

multiple Datalists data showing only on datalist

Manas Mohapatra can you help me this solution ..

No value given for one or more required parameters.