ado.net 数据库操作

/// <summary>
/// 存储过程调用返回dataset
/// </summary>
/// <param name="proname">存储过程名</param>
/// <param name="parameters">参数</param>
/// <returns></returns>
public DataSet proRecharge(string proname, params SqlParameter[] parameters)
{
	using (SqlConnection con = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]))
	{
		con.Open();
		using (SqlCommand cmd = new SqlCommand(proname, con))
		{
			cmd.CommandType = CommandType.StoredProcedure;
			cmd.Parameters.AddRange(parameters);
			SqlDataAdapter adapter = new SqlDataAdapter(cmd);
			DataSet ds = new DataSet();
			adapter.Fill(ds);
			return ds;
		}
	}
}