using System;
using System.Data;
using System.Data.SqlClient;
using System.Collections;
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;
namespace webBird
{
/// <summary>
/// sqlSever的数据库Bird操作类
/// 世界很美好. 如此.
/// DBClass db=new DBClass(conn)
/// db.close()
/// </summary>
public class DBClass
{
private SqlConnection conn;
private DBClass()
{
//
// TODO: 在此处添加构造函数逻辑
//
}
/// <summary>
/// 构造函数,初次构造时候,自动建立连接
/// </summary>
/// <param name="connstring">传过来的连接字符串</param>
public DBClass(string connstring)
{
conn = new SqlConnection(connstring);
if (conn.State == ConnectionState.Closed)
conn.Open();
}
/// <summary>
/// 呵呵, 忘记释放的时候自动释放掉
/// </summary>
/* ~DBClass()
{
if (conn.State == ConnectionState.Open)
conn.Close();
}*/
/// <summary>
/// 如果没有从构造函数建立连接, 手动建立用
/// </summary>
public SqlConnection Conn
{
get { return conn; }
}
#region 返回一条记录
/// <summary>
/// 找到查询到的一个数据行
/// </summary>
/// <param name="mycon">需要查询的数据库连接</param>
/// <param name="sql">sql语句</param>
/// <returns>返回一个数据行</returns>
public static DataRow GetDataRow(SqlConnection mycon, string sql)
{
try
{
SqlDataAdapter sqlAdapter1 = new SqlDataAdapter(sql, mycon);
DataSet ds = new DataSet();
sqlAdapter1.Fill(ds);
return ds.Tables[0].Rows[0];
}
catch (Exception ex)
{
throw (ex);
}
}
/// <summary>
/// 找到查询到的一个数据行
/// </summary>
/// <param name="mycon">需要查询的数据库连接</param>
/// <param name="sql">sql语句</param>
/// <returns>返回一个数据行</returns>
public static DataRow GetDataRow(SqlConnection mycon, string sql, string TableName)
{
try
{
SqlDataAdapter sqlAdapter1 = new SqlDataAdapter(sql, mycon);
DataSet ds = new DataSet();
sqlAdapter1.Fill(ds, TableName);
return ds.Tables[0].Rows[0];
}
catch (Exception ex)
{
throw (ex);
}
}
/// <summary>
/// 找到查询到的一个数据行
/// </summary>
/// <param name="sql">sql语句</param>
/// <param name="TableName">需要查询的表</param>
/// <returns>返回一个数据行</returns>
public DataRow GetDataRow(string sql, string TableName)
{
try
{
SqlDataAdapter sqlAdapter1 = new SqlDataAdapter(sql, conn);
DataSet ds = new DataSet();
sqlAdapter1.Fill(ds, TableName);
return ds.Tables[0].Rows[0];
}
catch (Exception ex)
{
throw (ex);
}
}
/// <summary>
/// 找到查询到的一个数据行
/// </summary>
/// <param name="sql">sql语句</param>
/// <returns>返回一个数据行</returns>
public DataRow GetDataRow(string sql)
{
try
{
SqlDataAdapter sqlAdapter1 = new SqlDataAdapter(sql, conn);
DataSet ds = new DataSet();
sqlAdapter1.Fill(ds);
return ds.Tables[0].Rows[0];
}
catch (Exception ex)
{
throw (ex);
}
}
#endregion
#region 执行Insert或Update语句
/// <summary>
/// 执行一个sql语句
/// INSERT mytable (mycolumn) VALUES (‘some data')
/// DELETE mytable WHERE first_column='Deltet Me'
/// UPDATE mytable SET first_column='Updated!' WHERE second_column='Update Me!'
/// </summary>
/// <param name="sql">sql语句</param>
public void ExcSQL(string sql)
{
try
{
SqlCommand sqlCmd = new SqlCommand(sql, conn);
sqlCmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw (ex);
}
}
/// <summary>
/// 执行一条sql语句
/// </summary>
/// <param name="mycon">需要执行语句的数据库连接</param>
/// <param name="sql">sql语句</param>
public static void ExcSQL(SqlConnection mycon, string sql)
{
try
{
SqlCommand sqlCmd = new SqlCommand(sql, mycon);
sqlCmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw (ex);
}
}
#endregion
#region 返回指定的记录集
/// <summary>
/// 从sql语句返回一个数据表
/// </summary>
/// <param name="sql">要执行的sql语句</param>
/// <param name="start">从这个开始点开始返回结果</param>
/// <param name="size">从开始点到要求结束点的中间大小</param>
/// <param name="tablename">执行sql的表</param>
/// <returns></returns>
public DataTable SelectFormForum(string sql, int start, int size, string tablename)
{
try
{
SqlDataAdapter sqlAdapter1 = new SqlDataAdapter(sql, conn);
DataSet ds = new DataSet();
sqlAdapter1.Fill(ds, start, size, tablename);
return ds.Tables[0];
}
catch (Exception ex)
{
throw (ex);
}
}
/// <summary>
/// 从sql语句返回一个数据表
/// </summary>
/// <param name="mycon">执行查询的数据库连接</param>
/// <param name="sql">要执行的sql语句</param>
/// <param name="start">从这个开始点开始返回结果</param>
/// <param name="size">从开始点到要求结束点的中间大小</param>
/// <param name="tablename">执行sql的表</param>
/// <returns>执行sql的表</returns>
public static DataTable SelectFormForum(SqlConnection mycon, string sql, int start, int size, string tablename)
{
try
{
SqlDataAdapter sqlAdapter1 = new SqlDataAdapter(sql, mycon);
DataSet ds = new DataSet();
sqlAdapter1.Fill(ds, start, size, tablename);
return ds.Tables[0];
}
catch (Exception ex)
{
throw (ex);
}
}
#endregion
#region 返回记录集
/// <summary>
/// 从sql语句返回一个数据表
/// </summary>
/// <param name="sql">sql语句</param>
/// <param name="tablename">查询的表名</param>
/// <returns>返回一个DataTable</returns>
public DataTable SelectFormForum(string sql, string tablename)
{
try
{
SqlDataAdapter sqlAdapter1 = new SqlDataAdapter(sql, conn);
DataSet ds = new DataSet();
sqlAdapter1.Fill(ds, tablename);
return ds.Tables[0];
}
catch (Exception ex)
{
throw (ex);
}
}
/// <summary>
/// 从sql语句返回一个数据表
/// </summary>
/// <param name="sql">sql语句</param>
/// <returns>返回一个DataTable</returns>
public DataTable SelectFormForum(string sql)
{
try
{
SqlDataAdapter sqlAdapter1 = new SqlDataAdapter(sql, conn);
DataSet ds = new DataSet();
sqlAdapter
using System.Data;
using System.Data.SqlClient;
using System.Collections;
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;
namespace webBird
{
/// <summary>
/// sqlSever的数据库Bird操作类
/// 世界很美好. 如此.
/// DBClass db=new DBClass(conn)
/// db.close()
/// </summary>
public class DBClass
{
private SqlConnection conn;
private DBClass()
{
//
// TODO: 在此处添加构造函数逻辑
//
}
/// <summary>
/// 构造函数,初次构造时候,自动建立连接
/// </summary>
/// <param name="connstring">传过来的连接字符串</param>
public DBClass(string connstring)
{
conn = new SqlConnection(connstring);
if (conn.State == ConnectionState.Closed)
conn.Open();
}
/// <summary>
/// 呵呵, 忘记释放的时候自动释放掉
/// </summary>
/* ~DBClass()
{
if (conn.State == ConnectionState.Open)
conn.Close();
}*/
/// <summary>
/// 如果没有从构造函数建立连接, 手动建立用
/// </summary>
public SqlConnection Conn
{
get { return conn; }
}
#region 返回一条记录
/// <summary>
/// 找到查询到的一个数据行
/// </summary>
/// <param name="mycon">需要查询的数据库连接</param>
/// <param name="sql">sql语句</param>
/// <returns>返回一个数据行</returns>
public static DataRow GetDataRow(SqlConnection mycon, string sql)
{
try
{
SqlDataAdapter sqlAdapter1 = new SqlDataAdapter(sql, mycon);
DataSet ds = new DataSet();
sqlAdapter1.Fill(ds);
return ds.Tables[0].Rows[0];
}
catch (Exception ex)
{
throw (ex);
}
}
/// <summary>
/// 找到查询到的一个数据行
/// </summary>
/// <param name="mycon">需要查询的数据库连接</param>
/// <param name="sql">sql语句</param>
/// <returns>返回一个数据行</returns>
public static DataRow GetDataRow(SqlConnection mycon, string sql, string TableName)
{
try
{
SqlDataAdapter sqlAdapter1 = new SqlDataAdapter(sql, mycon);
DataSet ds = new DataSet();
sqlAdapter1.Fill(ds, TableName);
return ds.Tables[0].Rows[0];
}
catch (Exception ex)
{
throw (ex);
}
}
/// <summary>
/// 找到查询到的一个数据行
/// </summary>
/// <param name="sql">sql语句</param>
/// <param name="TableName">需要查询的表</param>
/// <returns>返回一个数据行</returns>
public DataRow GetDataRow(string sql, string TableName)
{
try
{
SqlDataAdapter sqlAdapter1 = new SqlDataAdapter(sql, conn);
DataSet ds = new DataSet();
sqlAdapter1.Fill(ds, TableName);
return ds.Tables[0].Rows[0];
}
catch (Exception ex)
{
throw (ex);
}
}
/// <summary>
/// 找到查询到的一个数据行
/// </summary>
/// <param name="sql">sql语句</param>
/// <returns>返回一个数据行</returns>
public DataRow GetDataRow(string sql)
{
try
{
SqlDataAdapter sqlAdapter1 = new SqlDataAdapter(sql, conn);
DataSet ds = new DataSet();
sqlAdapter1.Fill(ds);
return ds.Tables[0].Rows[0];
}
catch (Exception ex)
{
throw (ex);
}
}
#endregion
#region 执行Insert或Update语句
/// <summary>
/// 执行一个sql语句
/// INSERT mytable (mycolumn) VALUES (‘some data')
/// DELETE mytable WHERE first_column='Deltet Me'
/// UPDATE mytable SET first_column='Updated!' WHERE second_column='Update Me!'
/// </summary>
/// <param name="sql">sql语句</param>
public void ExcSQL(string sql)
{
try
{
SqlCommand sqlCmd = new SqlCommand(sql, conn);
sqlCmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw (ex);
}
}
/// <summary>
/// 执行一条sql语句
/// </summary>
/// <param name="mycon">需要执行语句的数据库连接</param>
/// <param name="sql">sql语句</param>
public static void ExcSQL(SqlConnection mycon, string sql)
{
try
{
SqlCommand sqlCmd = new SqlCommand(sql, mycon);
sqlCmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw (ex);
}
}
#endregion
#region 返回指定的记录集
/// <summary>
/// 从sql语句返回一个数据表
/// </summary>
/// <param name="sql">要执行的sql语句</param>
/// <param name="start">从这个开始点开始返回结果</param>
/// <param name="size">从开始点到要求结束点的中间大小</param>
/// <param name="tablename">执行sql的表</param>
/// <returns></returns>
public DataTable SelectFormForum(string sql, int start, int size, string tablename)
{
try
{
SqlDataAdapter sqlAdapter1 = new SqlDataAdapter(sql, conn);
DataSet ds = new DataSet();
sqlAdapter1.Fill(ds, start, size, tablename);
return ds.Tables[0];
}
catch (Exception ex)
{
throw (ex);
}
}
/// <summary>
/// 从sql语句返回一个数据表
/// </summary>
/// <param name="mycon">执行查询的数据库连接</param>
/// <param name="sql">要执行的sql语句</param>
/// <param name="start">从这个开始点开始返回结果</param>
/// <param name="size">从开始点到要求结束点的中间大小</param>
/// <param name="tablename">执行sql的表</param>
/// <returns>执行sql的表</returns>
public static DataTable SelectFormForum(SqlConnection mycon, string sql, int start, int size, string tablename)
{
try
{
SqlDataAdapter sqlAdapter1 = new SqlDataAdapter(sql, mycon);
DataSet ds = new DataSet();
sqlAdapter1.Fill(ds, start, size, tablename);
return ds.Tables[0];
}
catch (Exception ex)
{
throw (ex);
}
}
#endregion
#region 返回记录集
/// <summary>
/// 从sql语句返回一个数据表
/// </summary>
/// <param name="sql">sql语句</param>
/// <param name="tablename">查询的表名</param>
/// <returns>返回一个DataTable</returns>
public DataTable SelectFormForum(string sql, string tablename)
{
try
{
SqlDataAdapter sqlAdapter1 = new SqlDataAdapter(sql, conn);
DataSet ds = new DataSet();
sqlAdapter1.Fill(ds, tablename);
return ds.Tables[0];
}
catch (Exception ex)
{
throw (ex);
}
}
/// <summary>
/// 从sql语句返回一个数据表
/// </summary>
/// <param name="sql">sql语句</param>
/// <returns>返回一个DataTable</returns>
public DataTable SelectFormForum(string sql)
{
try
{
SqlDataAdapter sqlAdapter1 = new SqlDataAdapter(sql, conn);
DataSet ds = new DataSet();
sqlAdapter