using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient1;
/// <summary>
/// admin 的摘要说明
/// </summary>
public class admin
{
conn conn = new conn();
static string 用户库名="admin";
static string 权限库名="right1";
public admin()
{
//
// TODO: 在此处添加构造函数逻辑
//
} public string1[] 登陆1(string 用户名,string 密码){ conn.SelectCommand = "select * from [" + 用户库名 + "] where admin=@用户名 and password=@密码";
conn.SelectParameters.Add("admin", admin);
conn.SelectParameters.Add("passwrod", password);
string[] temp = new string[2];
SqlDataReader dd = (SqlDataReader)conn.Select(DataSourceSelectArguments.Empty);
if (dd.HasRows)
{
dd.Read();
temp[0] = dd["id"].ToString();
temp[1] = dd["aleave"].ToString();
}
dd.Close();
return temp;
}
}上面这个要访问下面下面conn1.cs
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient1;
using System.Text;/// <summary>
/// conn 的摘要说明
/// </summary>
public class conn : SqlDataSource
{
public conn()
{
//
// TODO: 在此处添加构造函数逻辑
//
ConnectionString1 = "Data Source=192.168.0.4;Initial Catalog=库2;Persist Security Info=True;User ID=zhangjian;Password=cxgw";
DataSourceMode = System.Web.UI.WebControls.SqlDataSourceMode.DataReader;
}}
同时存在一个conn.cs
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient1;
using System.Text;/// <summary>
/// conn 的摘要说明
/// </summary>
public class conn : SqlDataSource
{
public conn()
{
//
// TODO: 在此处添加构造函数逻辑
//
ConnectionString1 = "Data Source=192.168.0.4;Initial Catalog=库1;Persist Security Info=True;User ID=zhangjian;Password=cxgw";
DataSourceMode = System.Web.UI.WebControls.SqlDataSourceMode.DataReader;
}}
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient1;
/// <summary>
/// admin 的摘要说明
/// </summary>
public class admin
{
conn conn = new conn();
static string 用户库名="admin";
static string 权限库名="right1";
public admin()
{
//
// TODO: 在此处添加构造函数逻辑
//
} public string1[] 登陆1(string 用户名,string 密码){ conn.SelectCommand = "select * from [" + 用户库名 + "] where admin=@用户名 and password=@密码";
conn.SelectParameters.Add("admin", admin);
conn.SelectParameters.Add("passwrod", password);
string[] temp = new string[2];
SqlDataReader dd = (SqlDataReader)conn.Select(DataSourceSelectArguments.Empty);
if (dd.HasRows)
{
dd.Read();
temp[0] = dd["id"].ToString();
temp[1] = dd["aleave"].ToString();
}
dd.Close();
return temp;
}
}上面这个要访问下面下面conn1.cs
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient1;
using System.Text;/// <summary>
/// conn 的摘要说明
/// </summary>
public class conn : SqlDataSource
{
public conn()
{
//
// TODO: 在此处添加构造函数逻辑
//
ConnectionString1 = "Data Source=192.168.0.4;Initial Catalog=库2;Persist Security Info=True;User ID=zhangjian;Password=cxgw";
DataSourceMode = System.Web.UI.WebControls.SqlDataSourceMode.DataReader;
}}
同时存在一个conn.cs
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient1;
using System.Text;/// <summary>
/// conn 的摘要说明
/// </summary>
public class conn : SqlDataSource
{
public conn()
{
//
// TODO: 在此处添加构造函数逻辑
//
ConnectionString1 = "Data Source=192.168.0.4;Initial Catalog=库1;Persist Security Info=True;User ID=zhangjian;Password=cxgw";
DataSourceMode = System.Web.UI.WebControls.SqlDataSourceMode.DataReader;
}}
解决方案 »
- Drawing类下Image和contral类下Image怎么转换
- C# 的using System.Runtime.Serialization.Json;
- 在线等,求高手解决,c#中collection<实体类>如何转换成dataset
- 如何同时设置listview的行高和标题可以点击
- 用installshield 12做安装文件的安装目录问题
- checkedListBox 中可不可以存两个或三个值
- C#下TextBox里的Scrollbar的问题
- 如何从数据库的一个表中获得一列值,将它存进一个float数组中?急,在线等!
- 难题!求救!!类型转换问题
- .NET redis连接数没有释放,在线等,谢谢。
- GridView
- 动态添加菜单
然后要调用的话
conn1 _c1 = new conn1();
conn2 _c2 = new conn2();