Dim sql As New StringBuilder
sql.Append("not(projectID=@projectID) ")
If m_orderType.SelectedValue > 0 Then
sql.Append("&&
project_typeID=@project_typeID ")
End If
If ddlm_subtype.SelectedValue > 0 Then
sql.Append("&&
project_subType=@project_subType ")
End If
If ddlm_ServiceLang.SelectedValue > 0 Then
sql.Append("&&
proServiceLang=@proServiceLang ")
End If
LinqDataSource1.WhereParameters.Clear()
LinqDataSource1.Where
= sql.ToString
LinqDataSource1.WhereParameters.Add("projectID", "0")
LinqDataSource1.WhereParameters.Add("project_typeID",
m_orderType.SelectedValue)
LinqDataSource1.WhereParameters.Add("project_subType",
ddlm_subtype.SelectedValue)
LinqDataSource1.WhereParameters.Add("proServiceLang",
ddlm_ServiceLang.SelectedValue)
LinqDataSource1.DataBind()
ไม่มีความคิดเห็น:
แสดงความคิดเห็น