如何指定我要访问得数据库
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;
}
}
...全文
相关推荐
Oracle数据库链Database links
Oracle数据库链Database links
基于虚拟仪器技术自动测试与数据管理系统
在虚拟仪器开发中必须解决专业软件和数据库之间的数据传输和调用问题,而LabVIEW 现有的版本中没有提供与通用数据库直接接口的方法。这一问题可以采用以下几种方法解决 。
Berkeley DB使用文档大全
描述了Berkeley DB的使用,含有原代码和说明文档
OLE DB 访问接口 SQLNCLI 的架构行集 DBSCHEMA_TABLES_INFO
OLE DB 访问接口 SQLNCLI 的架构行集 DBSCHEMA_TABLES_INFO OLE DB 访问接口 SQLNCLI 的架构行集
LabVIEW中实现数据库远程访问.
labview ,数据库远程访问,通过链接地址


