建立TreeView出错,出错提示:已有打开的与此连接相关联的dATArEADER,必须首先将它关闭
public static void AddMenuTreeView(TreeView FTreeView)
{
string is_menuid="",is_menuname="";
string is_modelid="",is_modelname="";
SqlCommand MenuModelSql=new SqlCommand("select menuid,menuname from MENUMODEL",DataBaseConnect.ReturnConnectString);
SqlDataReader dr_MenuModel ;
SqlDataReader dr_Menu ;
dr_MenuModel=MenuModelSql.ExecuteReader();
while (dr_MenuModel.Read())
{
is_menuid=dr_MenuModel.GetString(0);is_menuname=dr_MenuModel.GetString(1);
TreeViewNode cRoot=new TreeViewNode(is_menuname);
FTreeView.Nodes.Add(cRoot);
SqlCommand MenuSql=new SqlCommand("select modelid,modelname from view_menu where menuid='"+is_menuid+"'",DataBaseConnect.ReturnConnectString);
dr_Menu=MenuSql.ExecuteReader();
while (dr_Menu.Read())
{
is_modelid=dr_Menu.GetString(0);
is_modelname=dr_Menu.GetString(1);
}
dr_Menu.Close();
}
}
当程序运行到这句时:dr_Menu=MenuSql.ExecuteReader();
出错:已有打开的与此连接相关联的dATArEADER,必须首先将它关闭