using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
成都创新互联是一家专注于网站制作、网站建设与策划设计,东港网站建设哪家好?成都创新互联做网站,专注于网站建设十载,网设计领域的专业建站公司;建站业务涵盖:东港等地区。东港做网站价格咨询:18980820575
///
///DBOperate 的摘要说明
///
public class DBOperate
{
private static SqlConnection con = null;
private static SqlCommand cmd = null;
private static SqlDataAdapter da = null;
// private static SqlDataReader dr = null;
public static SqlConnection createCon()
{
string constr = ConfigurationManager.AppSettings["server"];
//string constr = ConfigurationManager.ConnectionStrings["connection"].ToString();
con = new SqlConnection(constr);
return con;
}
public static int execSQL(string sql)
{
int rows;
try
{
con = createCon();
if (con.State != ConnectionState.Open)
con.Open();
cmd = new SqlCommand(sql, con);
rows= cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception e)
{
throw new Exception(e.Message, e);
}
finally
{
if (con.State == ConnectionState.Open)
con.Close();
}
return rows;
}
public static DataSet getDataSet(string sql, string table)
{
try
{
con = createCon();
da = new SqlDataAdapter(sql, con);
DataSet ds = new DataSet();
da.Fill(ds, table);
return ds;
}
catch (Exception e)
{
throw new Exception(e.Message, e);
}
}
public static SqlDataReader getReader(string sql)
{
try
{
con = createCon();
if (con.State != ConnectionState.Open)
con.Open();
cmd = new SqlCommand(sql, con);
return cmd.ExecuteReader();
}
catch (Exception e)
{
throw new Exception(e.Message, e);
}
}
}