Author: TimTheWizard | Posted on: 9/15/2008 4:32:54 PM | Views : 293

Hi all,

 I'm having difficult with the C# code for pulling ArraryList info out and setting it as a variable, if anyone can help it would be greatly appreciated.

Here is my current code;

  string queryString = "SELECT * FROM database WHERE (some_where_statements);
SqlConnection connDB = new SqlConnection("Data Source=192.168.1.1;Initial Catalog=SOMEDB;Persist Security Info=True;User ID=someID;Password=#####");

{
connDB.Open();
SqlCommand command = new SqlCommand(queryString, connDB);
SqlDataReader reader = command.ExecuteReader();
ArrayList myArrList = new ArrayList();
if (reader.HasRows)
{
while (reader.Read())
{
// sequence is a fi ...

Go to the complete details ...