Reading SQL Server Column in an Array or List

Question

I want to know how to copy the values contained in a column in sql server database into an Array or a List? I'm using C# in a Web Application Project(ASP.NET)...

Thanks in advance

Answer 1

using (SqlConnection cnn = new SqlConnection("server=(local);database=pubs;Integrated Security=SSPI"))  {
 SqlDataAdapter da = new SqlDataAdapter("select name from authors", cnn); 
 DataSet ds = new DataSet(); 
 da.Fill(ds, "authors"); 

 List<string> authorNames = new List<string>();
 foreach(DataRow row in ds.Tables["authors"].Rows)
 {
   authorNames.Add(row["name"].ToString());
 }
}

Very basic example to fill author names into List.