using System;
using System.Data;
using System.Data.SqlClient;
using System.Collections;
class DBControl {
private static SqlConnection sqlConn; public DBControl(){
sqlConn = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["sqlConnectionString"]);
}
public DBControl(string sqlConnectionString){
sqlConn = new SqlConnection(sqlConnectionString);
}
public static DataTable GetDataTable(string sql,int start,int size,string tablename)
{
try
{
SqlDataAdapter sqlAdapter1 = new SqlDataAdapter(sql, sqlConn);
DataSet returns = new DataSet();
sqlAdapter1.Fill(returns,start,size,tablename);
return returns.Tables[0];
}
catch (Exception ex)
{
throw (ex);
}
finally
}
public static DataTable GetDataTable(string sql)
{
try
{
SqlDataAdapter sqlAdapter1 = new SqlDataAdapter(sql, sqlConn);
DataSet returns = new DataSet();
sqlAdapter1.Fill(returns);
return returns.Tables[0];
}
catch (Exception ex)
{
throw (ex);
}
finally
} public static int ExcuteSQL(string s)
{
try
{
SqlCommand sqlCmd =new SqlCommand(s,sqlConn);
sqlConn.Open();
return sqlCmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw (ex);
}
finally
}
//Ö´ÐÐselectÓï¾ä£¬·µ»Ø½á¹ûµÄSqlDataReader
public static SqlDataReader GetDataReader(string sql){
try
{
SqlCommand cmd = new SqlCommand(sql,sqlConn);
sqlConn.Open();
SqlDataReader reader = cmd.ExecuteReader();
return reader;
}
catch(Exception ex)
finally
}
public static DataRow GetDataRow(string sql,string TableName)
{
try
{
SqlDataAdapter sqlAdapter1 = new SqlDataAdapter(sql, sqlConn);
DataSet ds = new DataSet();
sqlAdapter1.Fill(ds, TableName);
return ds.Tables[0].Rows[0];
}
catch (Exception ex)
{
throw (ex);
}
finally
}
}
using System.Data;
using System.Data.SqlClient;
using System.Collections;
class DBControl {
private static SqlConnection sqlConn; public DBControl(){
sqlConn = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["sqlConnectionString"]);
}
public DBControl(string sqlConnectionString){
sqlConn = new SqlConnection(sqlConnectionString);
}
public static DataTable GetDataTable(string sql,int start,int size,string tablename)
{
try
{
SqlDataAdapter sqlAdapter1 = new SqlDataAdapter(sql, sqlConn);
DataSet returns = new DataSet();
sqlAdapter1.Fill(returns,start,size,tablename);
return returns.Tables[0];
}
catch (Exception ex)
{
throw (ex);
}
finally
}
public static DataTable GetDataTable(string sql)
{
try
{
SqlDataAdapter sqlAdapter1 = new SqlDataAdapter(sql, sqlConn);
DataSet returns = new DataSet();
sqlAdapter1.Fill(returns);
return returns.Tables[0];
}
catch (Exception ex)
{
throw (ex);
}
finally
} public static int ExcuteSQL(string s)
{
try
{
SqlCommand sqlCmd =new SqlCommand(s,sqlConn);
sqlConn.Open();
return sqlCmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw (ex);
}
finally
}
//Ö´ÐÐselectÓï¾ä£¬·µ»Ø½á¹ûµÄSqlDataReader
public static SqlDataReader GetDataReader(string sql){
try
{
SqlCommand cmd = new SqlCommand(sql,sqlConn);
sqlConn.Open();
SqlDataReader reader = cmd.ExecuteReader();
return reader;
}
catch(Exception ex)
finally
}
public static DataRow GetDataRow(string sql,string TableName)
{
try
{
SqlDataAdapter sqlAdapter1 = new SqlDataAdapter(sql, sqlConn);
DataSet ds = new DataSet();
sqlAdapter1.Fill(ds, TableName);
return ds.Tables[0].Rows[0];
}
catch (Exception ex)
{
throw (ex);
}
finally
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货