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

you can retrieve the datas in column to string ,then use split function and then for loop to store it in array — SAK
– SAK, Commented Jul 4, 2011 at 13:23
How are you planning to use the data in the resulting array? — Damien_The_Unbeliever
– Damien_The_Unbeliever, Commented Jul 4, 2011 at 13:42

Jethro · Accepted Answer · 2011-07-04 13:29:01Z

16

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.

answered Jul 4, 2011 at 13:29

Jethro

5,9413 gold badges25 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Madhivanan · Accepted Answer · 2011-07-04 13:26:37Z

2

See if this helps http://blog.sqlauthority.com/2009/11/25/sql-server-comma-separated-values-csv-from-table-column/

answered Jul 4, 2011 at 13:26

Madhivanan

13.7k1 gold badge28 silver badges30 bronze badges

Comments

Ovais Khatri · Accepted Answer · 2011-07-04 13:23:20Z

1

First you have to fill records in dataTable and then iterate through all rows of dataTable and add one by one each record to array list. Check this: http://www.dreamincode.net/code/snippet1864.htm

ArrayList obj = new ArrayList();
for(int x= 0;x<dtGet.Rows.Count;x++)
{
 obj.Add(dtGet.Rows[x]['col_name']);
}

answered Jul 4, 2011 at 13:23

Ovais Khatri

3,21118 silver badges15 bronze badges

Collectives™ on Stack Overflow

Reading SQL Server Column in an Array or List

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related