using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;

namespace Menu
{
class Program
{
static void Main(string[] args)
{
//获取菜单中父id为0的记录 list中的每个对象对应数据库中一条记录
List<MenuInfosMod> list = new List<MenuInfosMod>();
string connStr = "Data Source=WIN-MR86JSLEADS\\CCNN;Initial Catalog=Myschool;Integrated Security=True";
SqlConnection conn = new SqlConnection(connStr);
string cmdText = "select * from MenuInfos where ParentId=0";
SqlCommand cmd = new SqlCommand(cmdText,conn);
conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
Console.WriteLine(dr.ToString());
//获取dr中的字段个数
//Console.WriteLine(dr.FieldCount.ToString());
//for (int i = 0; i < dr.FieldCount; i++)
//{
// Console.WriteLine(dr.GetName(i)+" ");
//}
while(dr.Read()){
//dr[下标] dr[“字段名”]都可以
MenuInfosMod menuInfo = new MenuInfosMod();
menuInfo.MenuId = int.Parse(dr["MenuId"].ToString());
menuInfo.MenuName = dr["MenuName"].ToString();
menuInfo.ParentId = int.Parse(dr["ParentId"].ToString());
menuInfo.FrmName = dr["FrmName"].ToString();
list.Add(menuInfo);
}
//遍历list
//foreach (MenuInfosMod item in list)
//{
// Console.WriteLine(item.MenuName+" "+item.MenuId);
//}
//创建树
conn.Close();
Console.ReadKey();

}
}
}