🚀 go-pugleaf

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#.

On my Design tab I have place a ASP DropDownList control and called it 
ddlState.
I have placeed a System.Data.SqlClient.SqlCommand and added a simple sql 
select statement to it in code.
I have successfully created a connection to the database using 
sqlConnection.
I believe I have correctly opened up the sqlState using the 
sqlState.ExecuteReader command.
Now all I want to do is loop through the data to add dropdown elements to my 
ddlState control.
I understand there may be two ways to do this. One is to assign a DataSource 
to the ddlState control, and the other is to loop thru the retrieved data 
and use the Items.Add property.

Could someone get me over this concept by showing me a simple code snipet?

Thanks,  Wes

Here is what I have so far:
var
  connDarters : sqlConnection;
begin
   if ( not Page.IsPostBack)  then begin

        connDarters := sqlConnection.Create;
        connDarters.ConnectionString := '<my connection string to the sql 
database in here>';

        connDarters.Open;
        sqlState.Connection := connDarters;
        sqlState.CommandText := 'select STATE from StateTable order by 
STATE';
        sqlState.ExecuteReader;

// 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.

   end;

end;