Is there a quick way to query a database table in c# and push all the results into an arrayList?
Thanks
1
-
possibly. why do u ask?Naftali– Naftali2011-03-30 22:25:52 +00:00Commented Mar 30, 2011 at 22:25
Add a comment
|
3 Answers
If you're using SQL Server you can use LINQ. http://msdn.microsoft.com/en-us/vcsharp/aa336746
Comments
I like to use Microsoft Enterprise Library for database access. Once you have the libraries included in your project and a connection string defined in app.config it's very easy to run simple queries and map them to lists;
app.config
<connectionStrings>
<add name="Default" connectionString="server=LOCALHOST;database=MyDb; integrated security=SSPI" providerName="System.Data.SqlClient" />
</connectionStrings>
C#
class MyTable
{
public string Column1 { get; set; }
public string Column2 { get; set; }
}
var db = DatabaseFactory.CreateDatabase("Default");
var genericList = db.ExecuteSqlStringAccessor<MyTable>("select * from mytable").ToList();
Found the solution by guess and check. Can anyone verify that this code is relatively sound?
SqlConnection con = new SqlConnection(constr);
con.Open();
SqlCommand com = new SqlCommand(@"SELECT * FROM compsTickers", con);
SqlDataReader reader = com.ExecuteReader();
while (reader.Read())
{
tickerList.Add(reader.GetString(0));
}
reader.Close();
con.Close();