Your command object should be initialized after you define the query like -
Sql1 = "SELECT Count([Questions]) As Tq, SUM(case when [Compliance]= 'Yes ' then 1 else 0 end) As Yes, sum(case when [Compliance]= 'No ' then 1 else 0 end) As No,Sum(case when [Compliance]= 'NA ' then 1 else 0 end) As NA, (Count ([Questions]) - Sum(case when [Compliance]= 'NA ' then 1 else 0 end)) As Net FROM [APMCUBIntranet].[dbo].[AuditChaptHo] where Branch = '" & DropDownList6.Text & "' and Chapter ='CREDIT MANAGEMENT' and SubChap1 ='A.Common Observations' and convert(datetime,AuditStDt,103) between convert(datetime, '" & strDate1 & "',103) and convert(datetime,'" & strDate2 & "',103) "
cmd1 = New SqlCommand(Sql1, cnn1)
Hope, it helps :)