List<String> Res = new List<String>();
following way string objects are added to the List -
SqlConnection Conn = new SqlConnection(ConnectionString);
SqlCommand Cmd = new SqlCommand("SELECT CName FROM Categories", Conn);
Conn.Open();
SqlDataReader Categories = Cmd.ExecuteReader();
while (Categories.Read())
Res.Add(Categories.GetString(0));