Hello everyone,
I am using SQLite database for wpf windows application. But after using this query returning null. Here, Parameters are passing like this...
- string objImgNameArc = "Certificate,Forms";
- string objUserIdArc = "3,2";
- SELECT distinct Tble_Documents.Priority,Tble_Documents.UserId,Tble_UserSetUp.Function,Tble_UserSetUp.Department, Tble_UserSetUp.OrgCode, Tble_UserSetUp.FirstName|| ' ' ||Tble_UserSetUp.SurName as Fullname, Tble_Documents.Parent_File_Name, Tble_Documents.CreatedDate from Tble_Documents inner join Tble_UserSetUp on Tble_Documents.UserId = Tble_UserSetUp.Id where Tble_UserSetUp.UserType ='User' and Tble_UserSetUp.IsActive =1 and Tble_Documents.IsArchive = 1 and Tble_Documents.Parent_File_Name IN ('" + objImgNameArc + "') and Tble_UserSetUp.Id IN ('" + objUserIdArc + "')
Please help me.