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;
}
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;
}
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment