62,243
社区成员




public partial class xdes1 : System.Web.UI.Page
{
public static string sconfig = ConfigurationManager.ConnectionStrings["sanid"].ConnectionString;
public SqlConnection connn = new SqlConnection(sconfig);
protected void InitTree1()
{
connn.open();
SQLCOMMAND代码……
connn.close();
}
protected void InitTree2()
{
connn.open();
SQLCOMMAND代码……
connn.close();
}
protected void InitTree3()
{
connn.open();
SQLCOMMAND代码……
connn.close();
}
}
public partial class xdes2 : System.Web.UI.Page
{
protected void InitTree1()
{
SqlConnection connn = new SqlConnection(sconfig)
connn.open();
SQLCOMMAND代码……
connn.close();
}
protected void InitTree2()
{
SqlConnection connn = new SqlConnection(sconfig)
connn.open();
SQLCOMMAND代码……
connn.close();
}
protected void InitTree3()
{
SqlConnection connn = new SqlConnection(sconfig)
connn.open();
SQLCOMMAND代码……
connn.close();
}
}
protected void InitTree()
{
using(SqlConnection connn = new SqlConnection(sconfig))
{
conn.Open();
InitTree1(conn);
InitTree2(conn);
InitTree3(conn);
}
}
protected void InitTree1(....)
{
....
}
protected void InitTree2(....)
{
....
}
protected void InitTree3(....)
{
....
}
public partial class xdes1 : System.Web.UI.Page
{
public static string sconfig = ConfigurationManager.ConnectionStrings["sanid"].ConnectionString;
public SqlConnection connn = new SqlConnection(sconfig);
....
protected void InitTree2()
{
if(conn != null && conn.State != Connnect.State.Opened)
connn.open();
SQLCOMMAND代码……
if(conn != null && conn.State != Connnect.State.Closed)
connn.close();
}
....
}