62,046
社区成员
发帖
与我相关
我的任务
分享
OleDbConnection con=DBConnection.getConn();
con.Open();//打开连接
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.OleDb;
//using System.Data.Sql;
using System.IO;//上传文件
using System.Text;//编码
namespace _tjhdtx
{
/// <summary>
/// DBS 的摘要说明
/// </summary>
public class DBS
{
public DBS()
{
//下载于51aspx.com
// TODO: 在此处添加构造函数逻辑
//下载于51aspx.com
}
// static OleDbConnection con=DBConnection.getConn();
public static int sqlEx(string cmdstr)
{
// SqlConnection con = GetCon();//连接数据库
OleDbConnection con=DBConnection.getConn();
con.Open();//打开连接
OleDbCommand cmd = new OleDbCommand(cmdstr, con);
int recordcount = (int)cmd.ExecuteScalar();
try
{
//cmd.ExecuteNonQuery();//执行SQL 语句并返回受影响的行数
return recordcount;//成功返回1
}
catch
{
return 0;//失败返回0
}
finally
{
con.Dispose();//释放连接对象资源
}
}
public static int sqlExadu(string cmdstr)
{
OleDbConnection con=DBConnection.getConn();
con.Open();
OleDbCommand cmd = new OleDbCommand(cmdstr, con);
try
{
cmd.ExecuteNonQuery();//执行SQL 语句并返回受影响的行数
return 1;//成功返回1
}
catch
{
return 0;//失败返回0
}
finally
{
con.Dispose();//释放连接对象资源
}
}
public static void sqlTableUpdate(string cmdstr)
{
OleDbConnection con=DBConnection.getConn();
con.Open();
OleDbCommand cmdUpdate = new OleDbCommand(cmdstr, con);
cmdUpdate.ExecuteNonQuery();
con.Close();
}
public static DataTable reDatatable(string cmdstr)
{
OleDbConnection con=DBConnection.getConn();
con.Open();
OleDbDataAdapter da = new OleDbDataAdapter(cmdstr, con);
DataSet ds = new DataSet();
da.Fill(ds);
return (ds.Tables[0]);
}
/// <summary>
/// 返回指定Sql语句的DataTable
/// </summary>
/// <param name="sqlstr">传入的Sql语句</param>
/// <returns>DataTable</returns>
public static DataTable dataTable(string sqlstr)
{
OleDbConnection con=DBConnection.getConn();
con.Open();
OleDbCommand comm = new OleDbCommand();
OleDbDataAdapter da = new OleDbDataAdapter();
DataTable datatable = new DataTable();
try
{
comm.CommandType = CommandType.Text;
comm.CommandText = sqlstr;
da.SelectCommand = comm;
da.Fill(datatable);
}
catch (Exception)
{
}
finally
{
//closeConnection();
}
return datatable;
}
public static DataTable reDtanp(string cmdstr, int mypageindex, int mypagesize)
{
// SqlConnection con = GetCon();
OleDbConnection con=DBConnection.getConn();
con.Open();
OleDbDataAdapter da = new OleDbDataAdapter(cmdstr, con);
DataSet ds = new DataSet();
da.Fill(ds, mypagesize * (mypageindex - 1), mypagesize, "table");//利用 table表中从第 10 行开始的 15 行数据来填充 DataSet。
return (ds.Tables["table"]);
}