Torna al Thread
Dim str As String = Nothing
If chkf1.Checked Then
str = str & " AND idfornitore=" & ddlf1.SelectedValue.ToString
End If
If chkf2.Checked = True Then
str = str & " AND idtipo=" & ddlf2.SelectedValue.ToString
End If
If chkf3.Checked = True Then
str = str & " AND idtipoqta=" & ddlf3.SelectedValue.ToString
End If
If chkf4.Checked = True Then
str = str & " AND qualita=" & ddlf4.SelectedValue.ToString
End If
If chkf5.Checked = True Then
str = str & " AND iddeposito=" & ddlf5.SelectedValue.ToString
End If
If str <> Nothing Then
sqlcoils.SelectCommand = "select * from v_magazzino where kg > 0" & str & " order by sp ASC, larghezza ASC"
gridview1.DataBind()
Else
sqlcoils.SelectCommand = "select * from v_magazzino where kg > 0 order by sp ASC, larghezza ASC"
gridview1.DataBind()
End If