黑马程序员--C#数据库辅助类（简单版）

---------------------- Windows Phone 7手机开发、 .Net培训、期待与您交流！ ---------------------- class DBHelper

{

public static string ConnString

{

get { return System.Configuration.ConfigurationSettings.AppSettings["SqlConn"];}

}

《App.config里

<appSettings>

<add key="SqlConn" value="server=.;database=MyLogin; integrated security=SSPI"/>

</appSettings>

》

private SqlConnection conn = null;

private SqlCommand cmd = null;

private SqlDataReader red = null;

private DataSet dat = null;

private SqlDataAdapter ada = null;

public DBHelper()

{

conn = new SqlConnection(ConnString);

}

/// <summary>

/// 对数据进行增、删、改、查

/// </summary>

public int CommonChange(string cmdText, CommandType type)

{

int res;

cmd = new SqlCommand(cmdText, conn);

conn.Open();

cmd.CommandType = type;

res = cmd.ExecuteNonQuery();

conn.Close();

return res;

}

/// <summary>

/// 对数据进行增、删、改、查（存储过程）

/// </summary>

public int CommonChange(string cmdText, SqlParameter[] par, CommandType type)

{

int res;

cmd = new SqlCommand(cmdText, conn);

conn.Open();

cmd.CommandType = type;

if(par!=null)

cmd.Parameters.AddRange(par);

res = cmd.ExecuteNonQuery();

conn.Close();

return res;

}

/// <summary>

/// 查询返回结果集中首行、首列

/// </summary>

public object CommonScalar(string cmdText, CommandType type)

{

object obj;

cmd = new SqlCommand(cmdText, conn);

conn.Open();

cmd.CommandType = type;

obj = cmd.ExecuteScalar();

conn.Close();

return obj;

}

/// <summary>

/// 查询返回结果集中首行、首列（存储过程）

/// </summary>

public object CommonScalar(string cmdText, SqlParameter[] par, CommandType type)

{

object obj;

cmd = new SqlCommand(cmdText, conn);

conn.Open();

cmd.CommandType = type;

if(par!=null)

cmd.Parameters.AddRange(par);

obj = cmd.ExecuteScalar();

conn.Close();

return obj;

}

/// <summary>

/// 公共的内存数据集读取数据

/// </summary>

public DataSet CommonDataSet(string cmdText, CommandType type)

{

dat = new DataSet();

ada = new SqlDataAdapter(cmdText, conn);

ada.SelectCommand.CommandType = type;

ada.Fill(dat);

return dat;

}

/// <summary>

/// 公共的内存数据集读取数据（存储过程）

/// </summary>

public DataSet CommonDataSet(string cmdText, SqlParameter[] par, CommandType type)

{

dat = new DataSet();

ada = new SqlDataAdapter(cmdText, conn);

ada.SelectCommand.CommandType = type;

if(par!=null)

ada.SelectCommand.Parameters.AddRange(par);

ada.Fill(dat);

return dat;

}

/// <summary>

/// 读取数据记录

/// </summary>

public SqlDataReader CommonReader(string cmdText, CommandType type)

{

cmd = new SqlCommand(cmdText, conn);

conn.Open();

cmd.CommandType = type;

//让RED在关闭的时候，自动去关闭数据连接。

red = cmd.ExecuteReader(CommandBehavior.CloseConnection);

return red;

}

/// <summary>

/// 读取数据记录（存储过程）

/// </summary>

public SqlDataReader CommonReader(string cmdText, SqlParameter[] par, CommandType type)

{

cmd = new SqlCommand(cmdText, conn);

conn.Open();

cmd.CommandType = type;

if(par!=null)

cmd.Parameters.AddRange(par);

//让RED在关闭的时候，自动去关闭数据连接。

red = cmd.ExecuteReader(CommandBehavior.CloseConnection);

return red;

}

}

}

---------------------- Windows Phone 7手机开发、 .Net培训、期待与您交流！ ----------------------