新手问题，将数据库相关操作写在单独的类中，供网站其它页调用，如何作？
不好意思，刚学asp.net，用c#开发
想写一个类，包含static方法，实现连接数据库，public方法，实现查询等操作
如何写？
在网站其它页均可调用它，这样不需要每个网页都要声明类似sqlconnection等属性
在这些页中如何调用上面所说的类？

给个实例或给个说明
多谢

------解决方案--------------------
下个sqlHelper看看
------解决方案--------------------
直接使用sqlHelper这样的类库不就好了,这些东西是不用自己花时间去写的,浪费时间
------解决方案--------------------
/// <summary>
/// data access layer for my-sql
/// create by wujian at 2007-3-6
/// finally update by wujian at 2007-3-9
/// </summary>
public abstract class MySqlHelper
{
private string connectionString;
private MySqlConnection conn;
private MySqlCommand cmd;
private MySqlDataAdapter da;
private DataSet ds;
private DataTable dt;
//private MySqlDataReader dr;

public MySqlHelper(string inputConnectionString)
{
connectionString = inputConnectionString;
conn = new MySqlConnection(connectionString);
}

#region Build MySqlCommand
/// <summary> 无参数命令或存储过程构造MySqlCommand对象 </summary>
/// <param name= "commandTextOrProcedureName "> Sql命令或存储过程名 </param>
/// <param name= "commandType "> 类型(Sql命令或存储过程) </param>
private MySqlCommand buildSqlCommand(string commandTextOrProcedureName, CommandType commandType)
{
try
{
cmd = new MySqlCommand(commandTextOrProcedureName, this.conn);
cmd.CommandType = commandType;
return cmd;
}
catch (Exception error)
{
throw error;
}
}

/// <summary> 在新的MySqlConnection中以无参数命令或存储过程构造MySqlCommand对象 </summary>
/// <param name= "commandTextOrProcedureName "> Sql命令或存储过程名 </param>
/// <param name= "commandType "> 类型(Sql命令或存储过程) </param>
/// <param name= "newConn "> 新的MySqlConnection对象 </param>
private MySqlCommand buildSqlCommand(string commandTextOrProcedureName, CommandType commandType, MySqlConnection newConn)
{
try
{
cmd = new MySqlCommand(commandTextOrProcedureName, newConn);
cmd.CommandType = commandType;
return cmd;
}
catch (Exception error)
{
throw error;
}
}

/// <summary> 有参数命令或存储过程构造MySqlCommand对象 </summary>
/// <param name= "commandTextOrProcedureName "> Sql命令或存储过程名 </param>
/// <param name= "parameters "> MySqlParameter参数数组 </param>
/// <param name= "commandType "> 类型(Sql命令或存储过程) </param>
private MySqlCommand buildSqlCommand(string commandTextOrProcedureName, MySqlParameter[] parameters, CommandType commandType)
{
try
{
cmd = new MySqlCommand(commandTextOrProcedureName, this.conn);
cmd.CommandType = commandType;
foreach (MySqlParameter parameter in parameters)
{
cmd.Parameters.Add(parameter);
}