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
Copyright © dotNetHell.it 2002-2024
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5