?? connection.cs
字號:
using System;
using System.Configuration;
namespace _36Hang.Data
{
/// <summary>
/// Connection 的摘要說明。
/// </summary>
public class Connection
{
private string _Server;
private string _Database;
private string _Username;
private string _Password;
public Connection(string Server,string Database,string Username,string Password)
{
_Server = Server;
_Database = Database;
_Username = Username;
_Password = Password;
}
/// <summary>
/// 執(zhí)行數據庫查詢
/// </summary>
/// <param name="Sql">數據庫查詢語句</param>
public void Execute(string Sql)
{
try
{
SqlClient.Connection objConnection = new SqlClient.Connection(_Server,_Database,_Username,_Password);
objConnection.Execute(Sql);
}
catch(Exception e)
{
throw(e);
}
}
/// <summary>
/// 獲得數據庫查詢結果
/// 用于獲得全部查詢結果
/// </summary>
/// <param name="Sql">數據庫查詢語句</param>
/// <returns>數據庫查詢結果</returns>
public string Records(string Sql)
{
try
{
SqlClient.Connection objConnection = new SqlClient.Connection(_Server,_Database,_Username,_Password);
return objConnection.Records(Sql);
}
catch(Exception e)
{
throw(e);
}
}
/// <summary>
/// 獲得數據庫查詢結果
/// 用于獲取由 Page、Length 參數指定條件的查詢結果
/// </summary>
/// <param name="Sql">數據庫查詢語句</param>
/// <param name="Page">數據庫查詢結果的頁數</param>
/// <param name="Length">數據庫查詢結果的頁長</param>
/// <returns>數據庫查詢結果</returns>
public string Records(string Sql,int Page,int Length)
{
try
{
SqlClient.Connection objConnection = new SqlClient.Connection(_Server,_Database,_Username,_Password);
return objConnection.Records(Sql,Page,Length);
}
catch(Exception e)
{
throw(e);
}
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -