動態生成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);
        }

       

posted on 2008-10-31 15:44  雪中苍蝇  阅读(256)  评论(0)    收藏  举报

导航