如何指定我要访问得数据库
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;
}
}