Re: DataAdapter Select with Parameters

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: jack (jack_at_sonomaenterprises.com)
Date: 07/02/04 

Date: Fri, 2 Jul 2004 06:09:35 -0700

I removed the where clause and it returns all the records
with out error.

This is a windows application (not web), it a windows form
with a datagrid on the form.

I am sure once I understand the details of data access
in .NET it will be an improvement from V6, but right now
this is sooo frustrating. I spend hours getting basic
things working that took minutes in v6.......

>-----Original Message-----
>In the absence of a DataBind() statement, I assume you
are using Windows
>Forms. If this is the case, the bound data will be
reflected in the DataGrid
>each time it is changed.
>
>Your problem, looks as if its more related to the data
you are selected. For
>a test, try hard coding the select statement to retreive
known ' or all '
>values and then take it from there.
>
>HTH
>
>--
>
>OHM ( Terry Burns )
> . . . One-Handed-Man . . .
>
>Time flies when you don't know what you're doing
>
>"Jack" <Jack@sonomaenterprises.com> wrote in message
>news:2525e01c4602f$6b2f5510$a501280a@phx.gbl...
>> I have the following:
>>
>> * An OLEDBCommand with command text "SELECT CAMPAIGN,
>> DAY_OUT WHERE (CAMPAIGN LIKE '@campaign')"
>> * A DataAdapter that point the select to the above
command
>> * A data grid that I use to display the data
>> * form load code to populate the controls:
>> DsCampaign1 = New DataSet
>> cmdProActiTmp_Sel.Parameters.Item("@Campaign").Value = _
>> Trim(txtcampaign.Text())
>> DataAdapter1.Fill(DsCampaign1)
>> DataGrid1.SetDataBinding(DataAdapter1, _
>> cmdProActiTmp_Sel.ToString)
>>
>> The issue:
>>
>> I always get a zero result set, regardless of what the
>> value of txtcampaign.
>> TxtCampaign is null when the form first loads but
changes
>> based upon events on the form. How do I get the
datagrid
>> to refresh and use the value?
>
>
>.
>

Relevant Pages