السلام عليكــم ورحمـة الله وبركاتــه ،،
i made a datasource with sql statement but i get wrong result the SQL of that datasource is like that
SelectCommand=
"SELECT Date, Path, Name, Size, Id, Type,Title,Description FROM Video WHERE (Course = @Course) AND (Type = N'pdf') OR (Type = N'ppt') OR (Type = N'docx') OR (Type = N'doc)"
but i get course ID=1 and course ID=2 in may result depate that i select only course 2 to be displayed is that becoz "OR" statment
what i must do to get the specefic course whit only this type of format file -_-
waiting ............... its urgent
baraka ellah fikookom
ا