and (convert(varchar, DateIssue, 105) between @DateTo and @DateFrom  )

SELECT * FROM [Table2]

where  (ID like '%' + @ID  + '%' or ID=@ID   )

and(Pic_Mgr like '%' + @Picmgr + '%' or Pic_Mgr=@Picmgr)


and(DEPT like '%' + @dept + '%' or DEPT=@dept)

 and ( DateIssue between @DateTo and @DateFrom )

cmd.Parameters.AddWithValue("@ID", txtid.Text)
            cmd.Parameters.AddWithValue("@Dept", txtIssDept.Text)


            cmd.Parameters.AddWithValue("@Picmgr", txtPICMgr.Text)
            cmd.Parameters.AddWithValue("@DateTo", txtdateto.Text)
            cmd.Parameters.AddWithValue("@DateFrom", txtdatefrm.Text)