Infragistics Forums

Hello Infragistics Team,

    I've been back and forth with my ASP project and finally to the stored procedure call. For some reason when I enter the InitializeDataSource event it feeds in let's say 'o' is the e.Combo.DisplayValue, well I append a '%' in the function to make lQueryText = 'o%'

I run the SP and get back column values in the dataset but to my knowledge no data, also my ExceptionHandler is giving me the error:

"The expression contains invalid name: '[ ] LIKE 'o%''." that's 2 single quotes after the perfect and a period then double quote

Here's my code: 

Protected Sub WebComboCustomer_InitializeDataSource(ByVal sender As Object, ByVal e As Infragistics.WebUI.WebCombo.WebComboEventArgs) Handles WebComboCustomer.InitializeDataSource
        If Session("MyFlag") = 1 Then
            Exit Sub
        Else
            Dim lConnStr As String = ""
            Dim lDataSet As New DataSet
            Dim lDataTable As New DataTable
            Dim lSqlDa As New SqlClient.SqlDataAdapter
            Dim lQueryText As String = ""
            Dim lSqlConn As New SqlClient.SqlConnection(connectstring)
            Try
                If Not e.Combo.DisplayValue Is Nothing AndAlso e.Combo.DisplayValue.ToString.Trim.Length > 0 Then
                    lQueryText = e.Combo.DisplayValue.ToString.Trim + "%"
                Else
                    lQueryText = "%"
                End If
                lSqlConn.Open()
                With lSqlDa
                    .SelectCommand = New SqlClient.SqlCommand
                    With .SelectCommand
                        .CommandText = "spWebMasterCustomerCodeLike"
                        .CommandType = CommandType.StoredProcedure
                        .Parameters.Add("@Code", SqlDbType.VarChar, 7).Value = lQueryText
                        .Connection = lSqlConn
                    End With

                   .Fill(lDataTable)
                End With
                With WebComboCustomer
                    .DataSource = lDataTable
                    .DataBind()
                End With

            Catch ex As Exception
                MsgBox(ex.Message.ToString)
            Finally

                If Not lSqlConn Is Nothing Then
                    If lSqlConn.State = ConnectionState.Broken Or lSqlConn.State = ConnectionState.Closed Then
                    Else
                        lSqlConn.Close()
                    End If
                End If
            End Try
        End If
    End Sub
 

here's spWebMasterCustomerCodeLike:

Select CU_AcctNo, CU_AcctName, CU_AllowGuaranteedSvc from MasterCustomer

WHERE CU_AcctNo LIKE @Code

AND CU_Status = 1

Thanks

Any ideas / solutions would be greatly appreciated. 

Any ideas/suggestions would be greatly appreciated. Thanks 

Looking more in depth, looks as though my lDataTable has the rows that I need to return back to the WebCombo, however the .DataBind() event is supposed to bind them to the control, correct? What am I missing here, I have the data back in my lDataTable variable, however nothing is populating my WebCombo. Please help.

Really need a hand with this issue, I'm getting data back from the database and being held in lDataTable. When the data is to be filled in the WebComboCustomer it gives me the error:

"The expression contains invalid name: [ ] LIKE '%''."

How am I getting data back but nothing is being bound to the WebCombo? 

The expression contains invalid name: '[ LIKE 'o%''.

[SyntaxErrorException: The expression contains invalid name: '[ LIKE 'o%''.]
   System.Data.ExpressionParser.ScanName(Char chEnd, Char esc, String charsToEscape) +1308261
   System.Data.ExpressionParser.Scan() +533
   System.Data.ExpressionParser.Parse() +63
   System.Data.DataExpression..ctor(DataTable table, String expression, Type type) +124
   System.Data.DataView.set_RowFilter(String value) +161
   Infragistics.WebUI.UltraWebGrid.DBBinding.ProcessDataViewForFillRows(DataView dataView, RowsCollection rows) +497
   Infragistics.WebUI.UltraWebGrid.DBBinding.FillRows(UltraWebGrid grid, RowsCollection rows, IEnumerable datasource) +326
   Infragistics.WebUI.UltraWebGrid.DBBinding.BindList(IEnumerable datasource) +2801
   Infragistics.WebUI.UltraWebGrid.DBBinding.DataBind(Object dataSource, String dataMember) +1608
   Infragistics.WebUI.UltraWebGrid.UltraWebGrid.DataBind() +530
   Infragistics.WebUI.UltraWebGrid.UltraWebGrid.LoadPostData(String postDataKey, NameValueCollection values) +4763
   System.Web.UI.Page.ProcessPostData(NameValueCollection postData, Boolean fBeforeLoad) +661
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1194

Andy,

I suggest that you submit a support request to Developer Support.  This will likely require some in-depth investigation, and my impression is that there may be a bug that needs fixing.

When you do, please include a sample project that my staff can run and debug and which reproduces the problem.  That way, we can be sure we're running the same code that you are.  Since database connectivity seems relevant to the issue, I suggest using the Northwind database from either SQL Server or Access in your sample.