>I have a multi tiered application I am working on and want to know the following:
>
>Using C#, can you create procedure in your data class using a SqlDataReader? I want to fill a drop down list. This is easy to due with a DataSet. Can anyone give me or point me to an example of using a SqlDataReader in a data class?
>
>Thank you.
>
>Tom

IMHO it's also a correct way for static lists.

private void fillMyCombo()
{
  SqlConnection cn = new SqlConnection(
    "Persist Security Info=False;Integrated Security=SSPI;database=pubs;server=localhost");
  cn.Open() ;
  SqlDataReader rdr = new 
   SqlCommand("select * from authors",cn).ExecuteReader(CommandBehavior.CloseConnection);
  while (rdr.Read())
  {
    myCombo.Items.Add(String.Format("{0},{1}",rdr["au_fname"],rdr["au_lname"]));
  }
  cn.Close();
}

Cetin