🚀 go-pugleaf

Wes wrote:
> I am trying to access data from a SQL database and I cannot figure
> out the syntax for it using BDS 2006 in a .NET aspx. I am using the
> Delphi style syntax, not C#.
>
> Here is what I have so far:
>
> var
>   connDarters : sqlConnection;

// define a reader:
    rdr: SQLDataReader;
//[...]
>        connDarters.Open;
>        sqlState.Connection := connDarters;
>        sqlState.CommandText := 'select STATE from StateTable order by
> STATE';
>        sqlState.ExecuteReader;

// Above line needs to assign the reader result:
        rdr := sqlState.ExecuteReader;

// Now you can loop the returned rows:
        while rdr.Read do
        begin
>
> // This is whare further code most likely should be placed to fill in
> the drop-down
>
>        ddlState.Items.Add('TX');  // This was just a test to see if
> some data showed up in the drop-down. It worked.

          ddlState.Items.Add(rdr.Item['state'].ToString);
        end;

The alternative is to use a data adapter instead of a command object, use 
that to Fill a Dataset, and then just bind the dropdown to the dataset.


-- 
Wayne Niddery - Winwright, Inc (www.winwright.ca)
"The legitimate powers of government extend to such acts only as are
injurious to others. But it does me no injury for my neighbor to say
there are twenty gods, or no God. It neither picks my pocket nor breaks
my leg." � Thomas Jefferson