我建立了一个类库 内容如下
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;namespace DataBaseOperator
{
class SqlHelper
{
//链接字符串
private static string conString;
//属性
public static string ConString
{
get
{
return conString;
}
set
{
conString = value;
}
}
//设置执行命令的字符串
private static string cmdString;
public static string CmdString
{
get
{
return cmdString;
}
set
{
cmdString = value;
}
}
//链接对象
public static SqlConnection con; //执行简单的无返回值的操作
//增加、更新、删除操作
public static void SqlNoReturnResultCommand(string conString, string cmdString)
{
con = new SqlConnection(conString);
con.Open(); SqlCommand cmd = new SqlCommand(cmdString, con);
cmd.ExecuteNonQuery();
con.Close();
} //查询操作
public static SqlDataReader SqlSelectCommandReturnRead(string conString, string cmdString)
{
con = new SqlConnection(conString);
con.Open(); SqlCommand cmd = new SqlCommand(conString, con); SqlDataReader read = cmd.ExecuteReader(); return read; //想办法关闭链接啊!浪费资源
} public static DataSet SqlSelectCommandReturnDataSet(string conString, string cmdString)
{
con = new SqlConnection(conString);
con.Open(); SqlDataAdapter ad = new SqlDataAdapter(cmdString, con); DataSet ds = new DataSet(); ad.Fill(ds);
return ds;
}
}
}
然后将它生成了dll文件,我想在建立的网站(C#)中调用它的类,我将其添加到了项目中,
也用了
using DataBaseOperator
可是怎么调用不了啊?求大家帮助啊
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;namespace DataBaseOperator
{
class SqlHelper
{
//链接字符串
private static string conString;
//属性
public static string ConString
{
get
{
return conString;
}
set
{
conString = value;
}
}
//设置执行命令的字符串
private static string cmdString;
public static string CmdString
{
get
{
return cmdString;
}
set
{
cmdString = value;
}
}
//链接对象
public static SqlConnection con; //执行简单的无返回值的操作
//增加、更新、删除操作
public static void SqlNoReturnResultCommand(string conString, string cmdString)
{
con = new SqlConnection(conString);
con.Open(); SqlCommand cmd = new SqlCommand(cmdString, con);
cmd.ExecuteNonQuery();
con.Close();
} //查询操作
public static SqlDataReader SqlSelectCommandReturnRead(string conString, string cmdString)
{
con = new SqlConnection(conString);
con.Open(); SqlCommand cmd = new SqlCommand(conString, con); SqlDataReader read = cmd.ExecuteReader(); return read; //想办法关闭链接啊!浪费资源
} public static DataSet SqlSelectCommandReturnDataSet(string conString, string cmdString)
{
con = new SqlConnection(conString);
con.Open(); SqlDataAdapter ad = new SqlDataAdapter(cmdString, con); DataSet ds = new DataSet(); ad.Fill(ds);
return ds;
}
}
}
然后将它生成了dll文件,我想在建立的网站(C#)中调用它的类,我将其添加到了项目中,
也用了
using DataBaseOperator
可是怎么调用不了啊?求大家帮助啊
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货