?? datacon.cs
字號(hào):
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
namespace SMS.BaseClass
{
class DataCon
{
#region 建立數(shù)據(jù)庫連接
/// <summary>
/// 建立數(shù)據(jù)庫連接.
/// </summary>
/// <returns>返回SqlConnection對(duì)象</returns>
public SqlConnection getcon()
{
string M_str_sqlcon = "Data Source=(local);Database=db_SMS;User id=sa;PWD=";
SqlConnection myCon = new SqlConnection(M_str_sqlcon);
return myCon;
}
#endregion
#region 執(zhí)行SqlCommand命令
/// <summary>
/// 執(zhí)行SqlCommand
/// </summary>
/// <param name="M_str_sqlstr">SQL語句</param>
public void getcom(string M_str_sqlstr)
{
SqlConnection sqlcon = this.getcon();
sqlcon.Open();
SqlCommand sqlcom = new SqlCommand(M_str_sqlstr, sqlcon);
sqlcom.ExecuteNonQuery();
sqlcom.Dispose();
sqlcon.Close();
sqlcon.Dispose();
}
#endregion
#region 創(chuàng)建DataSet對(duì)象
/// <summary>
/// 創(chuàng)建一個(gè)DataSet對(duì)象
/// </summary>
/// <param name="M_str_sqlstr">SQL語句</param>
/// <param name="M_str_table">表名</param>
/// <returns>返回DataSet對(duì)象</returns>
public DataSet getds(string M_str_sqlstr, string M_str_table)
{
SqlConnection sqlcon = this.getcon();
SqlDataAdapter sqlda = new SqlDataAdapter(M_str_sqlstr, sqlcon);
DataSet myds = new DataSet();
sqlda.Fill(myds, M_str_table);
return myds;
}
#endregion
#region 創(chuàng)建SqlDataReader對(duì)象
/// <summary>
/// 創(chuàng)建一個(gè)SqlDataReader對(duì)象
/// </summary>
/// <param name="M_str_sqlstr">SQL語句</param>
/// <returns>返回SqlDataReader對(duì)象</returns>
public SqlDataReader getread(string M_str_sqlstr)
{
SqlConnection sqlcon = this.getcon();
SqlCommand sqlcom = new SqlCommand(M_str_sqlstr, sqlcon);
sqlcon.Open();
SqlDataReader sqlread = sqlcom.ExecuteReader(CommandBehavior.CloseConnection);
return sqlread;
}
#endregion
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -