Saturday, July 25, 2009

DataSet to Array List

Converting DataSet to Arrary String in C#

public static string[] GetArrayListX()
{
string[] ArrayListX = new string[] { };

string sqlCommand = "Select a_desc as descrption, a_id as ID FROM table Order by a_desc";
Database db = DatabaseFactory.CreateDatabase(); //Using Microsoft Enterprise Library
DbCommand dbCommand = db.GetSqlStringCommand(sqlCommand);

DataSet ds = db.ExecuteDataSet(dbCommand);

DataTable DT = ds.Tables[0];

DataRowCollection Rows = DT.Rows;

int icount = ds.Tables[0].Rows.Count;
int i = 0;
if (icount > 0)
{
ArrayListX = new string[icount];
foreach (DataRow row in Rows)
{
ArrayListX[i] = row["descrption"].ToString();
i++;
}
}


return ArrayList;
}

No comments:

Post a Comment