- 1PS提示：因為圖層已鎖定，無法編輯圖層的處理方法
- 2Adobe Illustrator CS5 序列號大全
- 3picacg蘋果版怎么找不到|picacg ios版是不是下架了介紹
- 4ACDsee注冊碼免費分享（含ACDsee18、ACDsee10等版本）
- 5蘋果iphone自動時間不準確的多種校正方法
- 6眼萌app怎么色弱測試 眼萌app色弱測試圖文說明教程
- 7百度安全衛士好用么_百度安全衛士技巧說明
- 8PDF瀏覽器能看3D文件嗎？PDF瀏覽器看3D文件圖文詳細教程
- 9Potato(馬鈴薯聊天)怎么注冊不了|Potato不能注冊處理方法介紹
- 10Potato(土豆聊天)怎么換頭像|Potato app更改頭像方法介紹
- 11ipad版office如何激活? office365激活的圖文說明教程
- 12最新的Adobe Illustrator CS4序列號大全
[摘要]/******************************* * 功能：數據庫操作相關 * 作者：FlashICP * 時間：2005-7-22 * ******************************/using System;using System.Data;using Syst...
/******************************** 功能：數據庫操作相關
* 作者：FlashICP
* 時間：2005-7-22
* ******************************/
using System;
using System.Data;
using System.Data.SqlClient;
using System.Web;
namespace moban
{
public class data
{
protected static string con="server=[yourserver];database=[yourdata];user id=[your id];password=[youpassword]";
//數據庫字符串
protected System.Data.SqlClient.SqlConnection DataConnection;
//數據庫連接對象
protected System.Data.SqlClient.SqlDataAdapter DataAdapter;
//SqlDataAdapter對象
protected System.Data.SqlClient.SqlCommand DataCommand;
//SqlCommand對象
protected System.Data.SqlClient.SqlCommandBuilder DataComBuilder;
//SqlCommandBuilder對象
protected System.Data.DataSet DataSet;
//DataSet對象
protected System.Data.DataRow DataRow;
//DataRow對象
protected System.Data.SqlClient.SqlDataReader DataReader=null;
//構造函數
public data()
{
DataConnection=DataConn();
}
//連接數據庫參數
public string Con
{
get{return con;}
set{con= value;}
}
//數據庫連接參數
public SqlConnection DataConn()
{
DataConnection=new SqlConnection(Con);
return DataConnection;
}
//返回數據庫連接對象
public SqlDataReader DataQuery(string Sql)
{
Sql=Sql.Replace("--","");
Sql=Sql.Replace(";","");
DataConnection=DataConn();
DataConnection.Open();
DataReader=null;
DataCommand=new SqlCommand(Sql,DataConnection);
DataReader=DataCommand.ExecuteReader();
DataCommand.Dispose();
return DataReader;
}
//返回DataSet
public virtual DataSet DataSetQuery(string Sql,string TableName)
{
DataConnection=DataConn();
DataAdapter=new SqlDataAdapter(Sql,DataConnection);
DataSet=new DataSet();
DataAdapter.Fill(DataSet,TableName);
DataAdapter.Dispose();
DataConnection.Close();
DataConnection.Dispose();
return DataSet;
}
//返回DataSet
public DataSet DataSetQuery(DataSet myds,string TableName,string Sql)
{
DataConnection=DataConn();
DataAdapter=new SqlDataAdapter(Sql,DataConnection);
DataAdapter.Fill(myds,TableName);
DataConnection.Close();
DataConnection.Dispose();
return DataSet;
}
//返回DataSet
public DataSet DataSetQuery(string Sql,string TableName,int StarIndex,int Count)
{
DataConnection=DataConn();
DataConnection.Open();
DataAdapter=new SqlDataAdapter(Sql,DataConnection);
DataSet=new DataSet();
DataAdapter.Fill(DataSet,StarIndex,Count,TableName);
DataConnection.Close();
DataConnection.Dispose();
return DataSet;
}
public void DataDo(string sqlstr)
{
DataConnection=DataConn();
SqlCommand mycom=DataConnection.CreateCommand();
mycom.CommandText=sqlstr;
DataConnection.Open();
mycom.ExecuteNonQuery();
DataConnection.Close();
}
//返回DataSet 開始行到結束行
public bool EditData(string Sql)
{
DataConnection=DataConn();
DataConnection.Open();
DataCommand=new SqlCommand(Sql,DataConnection);
try
{
DataCommand.ExecuteNonQuery();
DataConnection.Close();
return true;
}
catch(Exception ex)
{
System.Console.Write(ex.Message.ToString());
DataConnection.Close();
return false;
}
}
//執行成功返回真,否則返回假．
public object ExecuteScalar(string Sql)
{
DataConnection=DataConn();
DataConnection.Open();
DataCommand=new SqlCommand(Sql,DataConnection);
try
{
object back = DataCommand.ExecuteScalar();
DataConnection.Close();
return back;
}
catch(Exception ex)
{
System.Console.Write(ex.Message.ToString());
DataConnection.Close();
return null;
}
}
//返回一個值的查詢語句
public DataSet EditData(DataSet DataSet,SqlDataAdapter myda,string TableName)
{
DataComBuilder=new SqlCommandBuilder(myda);
myda.UpdateCommand=DataComBuilder.GetUpdateCommand();
myda.DeleteCommand=DataComBuilder.GetDeleteCommand();
myda.InsertCommand=DataComBuilder.GetInsertCommand();
myda.Update(DataSet,TableName);
DataSet.AcceptChanges();
this.CloseConnection();
return DataSet;
}
//修改DataSet 并且修改數據庫值存儲過程
public bool DataProcedure(string ProcedureName)
{
DataConnection=DataConn();
DataConnection.Open();
DataCommand=new SqlCommand();
DataCommand.CommandText=ProcedureName;
DataCommand.Connection=DataConnection;
DataCommand.CommandType=System.Data.CommandType.StoredProcedure;
try
{
DataCommand.ExecuteNonQuery();
return true;
}
catch(Exception ex)
{
System.Console.Write(ex.Message.ToString());
return false;
}
}
//無參數存儲過程的執行 返回執行真假
public void CloseConnection()
{
if(DataReader!=null)
{
DataReader.Close();
DataReader=null;
}
DataConnection.Close();
DataConnection.Dispose();
}
//關閉連接
}
}
標簽：C#中數據庫設置
推薦資訊 總人氣榜
相關文章
