| Author |
Populate a datagrid
|
|
|
| I am using the following syntax to populate a datagrid with the contents of
a recordset
Set dbgSalesAnalysisPC.DataSource = rsSalesAnalysisPC
Problem is nothing is appearing - there is definately data in the recordset
and I use this syntax quite often.
What might be causing this not to work?
If I set the datasource to a DataEnvironment it brings through the data fine
but I can't see how to set the parameters at runtime
Please help . . .
| |
| Douglas Marquardt 2005-03-04, 4:02 pm |
| Hi Ali:
Are you using ADO?
If so, then you need a client side cursor -- are you using that?
Doug.
"Ali" <nospamthanks@iveenuf.com> wrote in message news:ehnU7qLIFHA.244@TK2MSFTNGP10.phx.gbl...
> I am using the following syntax to populate a datagrid with the contents of
> a recordset
>
> Set dbgSalesAnalysisPC.DataSource = rsSalesAnalysisPC
>
> Problem is nothing is appearing - there is definately data in the recordset
> and I use this syntax quite often.
>
> What might be causing this not to work?
>
> If I set the datasource to a DataEnvironment it brings through the data fine
> but I can't see how to set the parameters at runtime
>
> Please help . . .
>
>
| |
| Newbie 2005-03-06, 3:58 pm |
| Thanks for the reply
Yes and yes in answer to your questions.
I have started a new project and copied the exact same code to new form and
it works.
How strange is that!
Any ideas What should I be looking for to troubleshoot it - I'm quite new to
this.
"Douglas Marquardt" <no_spam@dummy.com> wrote in message
news:uRQKaTMIFHA.3012@TK2MSFTNGP10.phx.gbl...
> Hi Ali:
>
> Are you using ADO?
>
> If so, then you need a client side cursor -- are you using that?
>
> Doug.
>
> "Ali" <nospamthanks@iveenuf.com> wrote in message
> news:ehnU7qLIFHA.244@TK2MSFTNGP10.phx.gbl...
>
>
| |
| sentinel 2005-03-07, 4:09 pm |
| Newbie wrote:
[color=darkred]
> Thanks for the reply
>
> Yes and yes in answer to your questions.
> I have started a new project and copied the exact same code to new
> form and it works.
>
> How strange is that!
>
> Any ideas What should I be looking for to troubleshoot it - I'm quite
> new to this.
> "Douglas Marquardt" <no_spam@dummy.com> wrote in message
> news:uRQKaTMIFHA.3012@TK2MSFTNGP10.phx.gbl...
> contents >> of
> data >> fine
I had the same problem and the sollution was simple
when you set datasource - the grid is automatiscy filled
if you set one column's datafield to something that doesn't exist in
the recordset then the whole grid went blank so i had to set each
column's datafield to fieldnames in rs...
|
|
|
|