62,074
社区成员
发帖
与我相关
我的任务
分享
using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
namespace PerformanceManagement.DLL
{
public class SqlServer
{
// private member variables
OleDbConnection con;
static String m_ConnectionString;
public SqlServer()
{
con = new OleDbConnection(ADOHelper.ConnectionString());
}
public DataSet ExecuteGet(string cmd)
{
this.CheckConnection();
DataSet dataSet = new DataSet();
try
{
OleDbCommand dataCommand = new OleDbCommand(cmd, con);
OleDbDataAdapter dataAdapter = new OleDbDataAdapter();
dataAdapter.SelectCommand = dataCommand;
dataAdapter.Fill(dataSet, "recordSet");
}
catch (SqlException se)
{
ErrorLog el = new ErrorLog(se);
throw new Exception("Error in SQL", se);
}
this.Dispose();
return dataSet;
}
public OleDbDataReader ExecuteRead(String cmd)
{
this.CheckConnection();
OleDbDataReader dr = null;
try
{
OleDbCommand dc = new OleDbCommand(cmd, con);
dr = dc.ExecuteReader();
return dr;
}
catch (SqlException se)
{
ErrorLog el = new ErrorLog(se);
}
this.Dispose();
return dr;
}
public void ExecuteUpdate(string cmd)
{
this.CheckConnection();
try
{
OleDbCommand dc = new OleDbCommand(cmd, con);
dc.ExecuteNonQuery();
}
catch (SqlException se)
{
ErrorLog el = new ErrorLog(se);
}
this.Dispose();
return;
}
private void CheckConnection()
{
try
{
if (con.State != ConnectionState.Open)
con.Open();
}
catch (System.Data.SqlClient.SqlException se)
{
ErrorLog el = new ErrorLog(se);
throw new Exception("Failed to Open connection.", se);
}
}
public static String ConnectionString()
{
// Pull the ConnectionString from the ASP+ AppSettings section.
// Cache in static field for faster repeat access.
if (m_ConnectionString == null)
{
m_ConnectionString = (String)ConfigurationSettings.AppSettings["ConnectionString"];
if (m_ConnectionString == null)
{
throw new Exception("Connect string value not set in Web.config");
}
}
return m_ConnectionString;
}
public void Dispose()
{
try
{
if (con.State == ConnectionState.Open)
con.Close();
//con = null;
}
catch (Exception e)
{
ErrorLog el = new ErrorLog(e);
}
}
}
}
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using Models;
namespace DAL
{
public class SqlHelper
{
// public SqlConnection getConn(string baseName,string userName,string userPwd)
// {
// SqlConnection conn = new SqlConnection("Data Source=(local);Database=" + baseName + ";Uid=" + userName + ";Pwd=" + userPwd + ";");
// return conn;
// }
private string baseName = "SingleExamSys";
private string userName = "sa";
private string userPwd = "sa";
/// <summary>
/// 传入参数数据库名,用户名与密码登陆
/// </summary>
/// <param name="baseName"></param>
/// <param name="userName"></param>
/// <param name="userPwd"></param>
public void setConn(string baseName, string userName, string userPwd)
{
this.baseName = baseName;
this.userName = userName;
this.userPwd = userPwd;
}
static SqlConnection conn;
public static void closeConn()
{
conn.Close();
}
public SqlConnection getConn()
{
conn = new SqlConnection("Data Source=(local);Database=" + baseName + ";Uid=" + userName + ";Pwd=" + userPwd + ";");
conn.Open();
return conn;
}
/// <summary>
/// 带有一个参数返回DataTble对象的方法
/// </summary>
/// <param name="cmdString"></param>
/// <returns></returns>
public DataTable getTable(string cmdString)
{
DataTable dt = new DataTable();
SqlConnection conn = getConn();
SqlDataAdapter sda = new SqlDataAdapter(cmdString, conn);
sda.Fill(dt);
conn.Close();
return dt;
}
/// <summary>
/// 带有一个参数返回SqlDataReader对象的方法
/// </summary>
/// <param name="cmdString"></param>
/// <returns></returns>
public SqlDataReader getReader(string cmdString)
{
SqlConnection conn = getConn();
SqlCommand com = new SqlCommand(cmdString, conn);
SqlDataReader rd = com.ExecuteReader();
//conn.Close();
return rd;
}
/// <summary>
/// 带有一个参数判断是否删除成功并返回bool值的方法
/// </summary>
/// <param name="delCmdString"></param>
/// <returns></returns>
public bool delData(string delCmdString)
{
SqlConnection conn = getConn();
SqlCommand com = new SqlCommand(delCmdString, conn);
int count = com.ExecuteNonQuery();
return testCount(count);
}
/// <summary>
/// 带有一个参数判断是否更新成功并返回bool值的方法
/// </summary>
/// <param name="updateCmdString"></param>
/// <returns></returns>
public bool updateData(string updateCmdString)
{
SqlConnection conn = getConn();
SqlCommand com = new SqlCommand(updateCmdString, conn);
int count = com.ExecuteNonQuery();
return testCount(count);
}
/// <summary>
/// 带有一个参数判断是否插入成功并返回bool值的方法
/// </summary>
/// <param name="insertCmdString"></param>
/// <returns></returns>
public bool insertData(string insertCmdString)
{
SqlConnection conn = getConn();
SqlCommand com = new SqlCommand(insertCmdString, conn);
int count = com.ExecuteNonQuery();
return testCount(count);
}
public bool testCount(int count)
{
bool flag = false;
if (count > 0)
{
flag = true;
}
return flag;
}
/// <summary>
/// 添加一行
/// </summary>
/// <param name="colName"></param>
/// <param name="tbName"></param>
/// <returns></returns>
public int getId(string colName, string tbName)
{
SqlConnection conn = getConn();
string str = "select MAX(" + colName + ") from " + tbName;
DataTable dt = getTable(str);
int id = Convert.ToInt32(dt.Rows[0][0].ToString());
return (id + 1);
}
/// <summary>
/// 判断是否存在数据项
/// </summary>
/// <param name="cmdSql"></param>
/// <returns></returns>
public bool existData(string cmdSql)
{
SqlConnection con = getConn();
SqlCommand cmd = new SqlCommand(cmdSql, con);
int count = Convert.ToInt32(cmd.ExecuteScalar());
if (count > 0)
return true;
return false;
}
}
}
这个能用来连接sql2000吗?