自定义的类ConnectToSql()可以调用,但getNavigateMenu()无法调用。高手帮我看看问题出在哪?
using System;
using System.Data;
using System.Data.SqlClient;
namespace DataAccess
{
/// <summary>
/// Conn 的摘要说明。
/// </summary>
public class Conn
{
protected SqlConnection con;
protected string navigateMenu;//是不是这里不对?
public Conn()
{
//
// TODO: 在此处添加构造函数逻辑
//
}
public SqlConnection ConnectToSql()
{
con = new SqlConnection("uid=sa;pwd=fitel;database=hidan");
con.Open();
return con;
} public string getNavigateMenu()//菜单获得
{
//string menuidString;
//if(menuidString == null)
//{
menuidString = "100";
//}
string queryString = "SELECT * FROM M_Menu WHERE menu_id = " + menuidString;
Conn myConn = new Conn();
SqlDataReader myDataReader ;
SqlCommand myCommand = new SqlCommand(queryString,myConn.ConnectToSql());
myDataReader = myCommand.ExecuteReader();
while(myDataReader.Read())
{
string menuTitle = null;
if(menuidString != "100")
{
menuTitle = "||<a href=index.aspx?menuid=100>首页</a>||";
}
navigateMenu = menuTitle+Convert.ToString(myDataReader["menu_main"]);
navigateMenu += "||" +"<a href=index.aspx?menuid="+menuidString+">" +Convert.ToString(myDataReader["menu_name"])+"</a>";
}
myDataReader.Close();
myConn.ConnectToSql().Close();
return navigateMenu;
} }
}
using System;
using System.Data;
using System.Data.SqlClient;
namespace DataAccess
{
/// <summary>
/// Conn 的摘要说明。
/// </summary>
public class Conn
{
protected SqlConnection con;
protected string navigateMenu;//是不是这里不对?
public Conn()
{
//
// TODO: 在此处添加构造函数逻辑
//
}
public SqlConnection ConnectToSql()
{
con = new SqlConnection("uid=sa;pwd=fitel;database=hidan");
con.Open();
return con;
} public string getNavigateMenu()//菜单获得
{
//string menuidString;
//if(menuidString == null)
//{
menuidString = "100";
//}
string queryString = "SELECT * FROM M_Menu WHERE menu_id = " + menuidString;
Conn myConn = new Conn();
SqlDataReader myDataReader ;
SqlCommand myCommand = new SqlCommand(queryString,myConn.ConnectToSql());
myDataReader = myCommand.ExecuteReader();
while(myDataReader.Read())
{
string menuTitle = null;
if(menuidString != "100")
{
menuTitle = "||<a href=index.aspx?menuid=100>首页</a>||";
}
navigateMenu = menuTitle+Convert.ToString(myDataReader["menu_main"]);
navigateMenu += "||" +"<a href=index.aspx?menuid="+menuidString+">" +Convert.ToString(myDataReader["menu_name"])+"</a>";
}
myDataReader.Close();
myConn.ConnectToSql().Close();
return navigateMenu;
} }
}
---------------------
怎么样个无法调用?是访问不到?这个好像不可能
还是调用结果与预期不符?
那个sql语句似乎还应该加个单引号:
string queryString = "SELECT * FROM M_Menu WHERE menu_id = '" + menuidString + "'";
{
// 在此处放置用户代码以初始化页面
DataAccess.Conn myConn = new DataAccess.Conn();
myConn.ConnectToSql(); //可以这样引用
myConn.GetMenu();//myConn.后面的GetMenu就出不来啊。
}
刚学.net,好多基本的概念不甚理解,请兄弟请点一下
应该是myConn.getNavigateMenu()