高手请解释含义!!!!!急啊!!在线等待
楼主发表于:2010-05-13 18:25:31using System;using System.Collections.Generic;
using System.Text;
namespace 人力资源管理系统
{
class DataBase:IDisposable
{
private SqlConnection SqlConn;
public static string sConn = "Persist Security Info=False;Integrated Security" + "=SSPI;database=hrmbook;server=192.168.10.2;Connect Timeout=30";
public void Dispose()
{
Dispose(true);
GC.SuppressFinalize(true);
}
protected void Dispose(bool disposing)
{
if (disposing)
return;
if (SqlConn != null)
{
SqlConn.Dispose();
SqlConn = null;
}
}
public void Open()
{
if (SqlConn == null)
{
SqlConn = new SqlConnection(sConn);
SqlConn.Open();
}
}
public void Close()
{
if (SqlConn != null)
SqlConn.Close();
}
public DataView RunSelectSQL(string sSQLString)
{
this.Open();
DataSet SqlDS = new DataSet();
SqlDataAdapter SqlDA = new SqlDataAdapter(sSQLString, this.SqlConn);
SqlDA.Fill(SqlDS);
return SqlDS.Tables[0].DefaultView;
}
public void RunDelOrInsSQL(string sSQLString)
{
this.Open();
SqlCommand SqlComm = new SqlCommand(sSQLString, this.SqlConn);
SqlComm.ExecuteNonQuery();
}
}
}
--------------------编程问答-------------------- 哪不明白?不会是全部的吧? --------------------编程问答-------------------- 数据库操作,,, --------------------编程问答-------------------- using System.Collections.Generic;
using System.Text;
namespace 人力资源管理系统
{
class DataBase:IDisposable
{
private SqlConnection SqlConn;
public static string sConn = "Persist Security Info=False;Integrated Security" + "=SSPI;database=hrmbook;server=192.168.10.2;Connect Timeout=30";
public void Dispose()
{
Dispose(true); //调用下面的带参数的Dispose(bool disposing)方法
GC.SuppressFinalize(true);
}
protected void Dispose(bool disposing)
{
if (disposing) //如果传的参数为True,则跳出方法
return;
if (SqlConn != null)
{
SqlConn.Dispose(); //如果数据库连接对象不为空,那么释放连接对象
SqlConn = null;
}
}
public void Open()
{
if (SqlConn == null)//如果数据库连接对象不为空,则打开连接对象
{
SqlConn = new SqlConnection(sConn); SqlConn.Open();
}
}
public void Close()//如果数据库连接对象不为空,则关闭连接对象
{
if (SqlConn != null)
SqlConn.Close();
}
public DataView RunSelectSQL(string sSQLString)//从数据库中读取数据
{
this.Open();
DataSet SqlDS = new DataSet();
SqlDataAdapter SqlDA = new SqlDataAdapter(sSQLString, this.SqlConn);
SqlDA.Fill(SqlDS);
return SqlDS.Tables[0].DefaultView;
}
public void RunDelOrInsSQL(string sSQLString)//执行SQL语句
{
this.Open();
SqlCommand SqlComm = new SqlCommand(sSQLString, this.SqlConn);
SqlComm.ExecuteNonQuery();
}
}
}
--------------------编程问答-------------------- using System.Collections.Generic;
using System.Text;
namespace 人力资源管理系统
{
class DataBase:IDisposable
{
private SqlConnection SqlConn;
public static string sConn = "Persist Security Info=False;Integrated Security" + "=SSPI;database=hrmbook;server=192.168.10.2;Connect Timeout=30";
public void Dispose()
{
Dispose(true); //调用下面的带参数的Dispose(bool disposing)方法
GC.SuppressFinalize(true);
}
protected void Dispose(bool disposing)
{
if (disposing) //如果传的参数为True,则跳出方法
return;
if (SqlConn != null)
{
SqlConn.Dispose(); //如果数据库连接对象不为空,那么释放连接对象
SqlConn = null;
}
}
public void Open()
{
if (SqlConn == null)//如果数据库连接对象不为空,则打开连接对象
{
SqlConn = new SqlConnection(sConn); SqlConn.Open();
}
}
public void Close()//如果数据库连接对象不为空,则关闭连接对象
{
if (SqlConn != null)
SqlConn.Close();
}
public DataView RunSelectSQL(string sSQLString)//从数据库中读取数据
{
this.Open();
DataSet SqlDS = new DataSet();
SqlDataAdapter SqlDA = new SqlDataAdapter(sSQLString, this.SqlConn);
SqlDA.Fill(SqlDS);
return SqlDS.Tables[0].DefaultView;
}
public void RunDelOrInsSQL(string sSQLString)//执行SQL语句
{
this.Open();
SqlCommand SqlComm = new SqlCommand(sSQLString, this.SqlConn);
SqlComm.ExecuteNonQuery();
}
}
}
--------------------编程问答-------------------- ADO.NET数据库操作
看msdn
http://msdn.microsoft.com/zh-cn/library/e80y5yhx(VS.80).aspx --------------------编程问答-------------------- 解释啥?
补充:.NET技术 , C#