Data from datasource into array in ASP.NET

[jonnyc23]

Hi there.

This is my first post although thescripts has solved many of my issues before through other people's threads.

My problem today seems simple but i can't crack it.

I'm simply trying to connect to an MSSQL database and get the data in two columns into two arrays. How hard can that be?
I've been trying to use an ObjectDataSource layer but i now think that isn't going to work so I'm moving on to having no middle layer and using a direct SQL connection but having trouble making that work too!

If anyone can offer me any helpful snippets, that'd be super.
I'm having to code in C#. My experience is mostly in php where everything seems a lot easier!!

Jon

[kenobewan]

One way would be to use a datareader to loop through creating the array. HTH.

[Vijey]

Hi..
First declear the variables both array and non-array;

String[] arryCol1;
String[] arryCol2;

DataSet ds;

string strCol1,strCol2,ColValue ;
try
{
//Fist fill the dataset as per your requirement
// So, now dataset (ds) is ready; // i didn't gave the code for that...

// here we are defining the array size
arryCol1 = new String[ds.Tables[0].Rows.Count];
arryCol2 = new String[ds.Tables[0].Rows.Count];

// In this for loop we are geting all the row values
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
strCol1= ds.Tables[0].Rows[i]["First_Column_Name"].ToString();
strCol2= ds.Tables[0].Rows[i]["Second_Column_Name"].ToString();
arryCol1[i] += strCol1;
arryCol2[i] += strCol2;
}
// Now the above two arrys arryCol1[], arryCol2[] contains the respective table column values.

// Inorder to verify this the below foreach loop will print the values
foreach (string Col1 in arryCol1)
{
ColValue += Col1 + ", ";
}
Response.Write(ColValue);
}
catch (Exception Ex)
{
lblMsg.Text = "Err Testing: " + Ex.Message;
}