動態生成DATATABLE
public static DataTable GetMenu()
{
DataTable dt = new DataTable("ID");
try
{
String str_Log = "select id,parent_id,menu_text,url,enabled,sort from menu order by sort";
DataSet dataSet = SqlServerAccess.ExecuteQuery(SqlServerAccess.enumDB.BuilderProject, str_Log);
dt.Columns.Add("id", typeof(String));
dt.Columns.Add("parent_id", typeof(String));
dt.Columns.Add("menu_text", typeof(String));
dt.Columns.Add("url", typeof(String));
dt.Columns.Add("enabled", typeof(String));
dt.Columns.Add("sort", typeof(int));
DataColumn[] key = new DataColumn[1];
key[0] = dt.Columns[0];
dt.PrimaryKey = key;
DataRow userRow;
foreach (DataTable table in dataSet.Tables)
{
foreach (DataRow row in table.Rows)
{
userRow = dt.NewRow();
userRow["id"] = row[0].ToString().Trim();
userRow["parent_id"] = row[1].ToString().Trim();
userRow["menu_text"] = row[2].ToString().Trim();
userRow["url"] = row[3].ToString().Trim();
userRow["enabled"] = row[4].ToString().Trim();
userRow["sort"] = row[5].ToString().Trim();
dt.Rows.Add(userRow);
}
}
return dt;
}
catch (Exception ex)
{
ErrHandle.Log("GetMenu.txt", ex.Message, ex.StackTrace);
}
return (dt);
}
浙公网安备 33010602011771号