Glad you got it sorted out.
On Fri, Jun 3, 2011 at 10:42 AM, Michael Brown <mbrown686877@...>wrote:
> It was my own operator error!!!! I had the textbox bound to another
> field!!!! Rooky I am!!!!
> Mike
>
> ------------------------------
> *From:* Waffqle <waffqle@...>
> *To:* Michael Brown <mbrown686877@...>
> *Sent:* Fri, June 3, 2011 9:27:35 AM
> *Subject:* Re: [Vantage] Filter an UltraGrid by a textbox value.
>
> Try sticking that in there after you fetch the data and see if you have rows, it could be that you're just binding it incorrectly.
> MessageBox.Show(dsUD21.Tables(0).Rows.Count.ToString())
>
>
>
> On Fri, Jun 3, 2011 at 9:52 AM, Michael Brown <mbrown686877@...>wrote:
>
>> I have tried that and it still returns no data. Even Dimmed the
>> whereClause just as string.
>> Mike Brown
>>
>> ------------------------------
>> *From:* Waffqle <waffqle@...>
>> *To:* Michael Brown <mbrown686877@...>
>> *Sent:* Fri, June 3, 2011 8:37:44 AM
>>
>> *Subject:* Re: [Vantage] Filter an UltraGrid by a textbox value.
>>
>> You're setting your whereClause after you've already looked up your data.
>> Try this:
>>
>> Private Sub btnStart_Click(ByVal Sender As Object, ByVal Args As System.EventArgs) Handles btnStart.Click
>> Dim txtKeyField As Object
>> Dim recSelected As Boolean
>> Dim whereClause As String = String.Empty
>> Dim UD21adapt As UD21Adapter = New UD21Adapter(UD07Form)
>> UD21adapt.BOConnect()
>> whereClause = "key1 = '" & txtKeyField & "'"
>> Dim dsUD21 As DataSet = Epicor.Mfg.UI.FormFunctions.SearchFunctions.listLookup(oTrans, "UD21Adapter", recSelected, False, whereClause)
>> ugdEpiCustom1.DataSource = dsUD21
>> MessageBox.Show("Complete")
>> End Sub
>>
>>
>>
>>
>> On Fri, Jun 3, 2011 at 7:59 AM, Michael Brown <mbrown686877@...>wrote:
>>
>>> Here is how I am populating the grid.
>>>
>>> Private Sub btnStart_Click(ByVal Sender As Object, ByVal Args As
>>> System.EventArgs) Handles btnStart.Click
>>> '// ** Place Event Handling Code Here **
>>> Dim txtKeyField As Object
>>> Dim recSelected As Boolean
>>> Dim whereClause As String = String.Empty
>>> Dim UD21adapt As UD21Adapter = New UD21Adapter(UD07Form)
>>> UD21adapt.BOConnect
>>> Dim dsUD21 As DataSet =
>>> Epicor.Mfg.UI.FormFunctions.SearchFunctions.listLookup(oTrans,
>>> "UD21Adapter", recSelected, False, whereClause)
>>> 'whereClause = "key1 = '%" & txtKeyField & "'%"
>>> ugdEpiCustom1.DataSource = dsUD21
>>> MessageBox.Show("Complete")
>>> End Sub
>>> Thanks
>>> Mike Brown
>>>
>>> ------------------------------
>>> *From:* Waffqle <waffqle@...>
>>> *To:* vantage@yahoogroups.com
>>> *Sent:* Thu, June 2, 2011 4:52:41 PM
>>> *Subject:* Re: [Vantage] Filter an UltraGrid by a textbox value.
>>>
>>> How are you populating your grid?
>>>
>>> On Thu, Jun 2, 2011 at 5:15 PM, Michael Brown <mbrown686877@...
>>> >wrote:
>>>
>>> >
>>> >
>>> > All,
>>> > I am trying to filter an Ultragrid with a textbox value and not having
>>> much
>>> >
>>> > luck. Does anyone out there possibly have a code snippet for this. What
>>> I
>>> > have
>>> > tried is
>>> > whereClause = To.String "Key1 = '" & txtKeyField & "'"
>>> > This doesn't return any data for me.
>>> >
>>> > Thanks
>>> > Mike Brown
>>> > D&S Manufacturing
>>> > mbrown@...
>>> >
>>> > [Non-text portions of this message have been removed]
>>> >
>>> >
>>> >
>>>
>>>
>>>
>>> --
>>> *Waffqle Driggers*
>>>
>>> *High End Dev, System Design, Profit Drinking
>>> *
>>> *:: 904.962.2887*
>>> *:: waffqle@...*
>>> *:: NO FAXES*
>>>
>>> *
>>>
>>>
>>> *
>>>
>>>
>>> [Non-text portions of this message have been removed]
>>>
>>>
>>>
>>> ------------------------------------
>>>
>>>
>>> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
>>> have already linked your email address to a yahoo id to enable access. )
>>> (1) To access the Files Section of our Yahoo!Group for Report Builder and
>>> Crystal Reports and other 'goodies', please goto:
>>> http://groups.yahoo.com/group/vantage/files/.
>>> (2) To search through old msg's goto:
>>> http://groups.yahoo.com/group/vantage/messages
>>> (3) To view links to Vendors that provide Vantage services goto:
>>> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>>>
>>>
>>>
>>>
>>>
>>
>>
>> --
>> *Waffqle Driggers*
>> *High End Dev, System Design, Profit Drinking
>> *
>> *:: 904.962.2887*
>> *:: waffqle@...*
>> *:: NO FAXES*
>>
>> *
>>
>> *
>>
>
>
>
> --
> *Waffqle Driggers*
> *High End Dev, System Design, Profit Drinking
> *
> *:: 904.962.2887*
> *:: waffqle@...*
> *:: NO FAXES*
>
> *
>
> *
>
--
*Waffqle Driggers*
*High End Dev, System Design, Profit Drinking
*
*:: 904.962.2887*
*:: waffqle@...*
*:: NO FAXES*
*
*
[Non-text portions of this message have been removed]