谁帮我补充完这段代码，谢谢啦！~

Question

我现在有一个aspx页，下面是其中的代码： 
<%@ Page Language="C#" ContentType="text/html" ResponseEncoding="gb2312" %> 
<%@ Import Namespace="System.Data" %> 
<%@ Import Namespace="System.Data.SqlClient" %> 
<%@ Import Namespace="System.Data.OleDb" %> …… 
…… <script language="c#" runat="server" > String mid; Database allcity = new Database(ConfigurationSettings.AppSettings["数据库路径"]); 
void Page_Load(Object scr, EventArgs e) 
{ 
if(!IsPostBack) 
{         Database alltrip = new Database(ConfigurationSettings.AppSettings["数据库路径"]); DataList_tuijian.DataSource=(alltrip.SQL_SelectSQL_DataSet("select top 6 * from tripproduct  where trip_flag=1 order by id desc","tripproduct")).Tables["tripproduct"]; 
DataList_tuijian.DataBind(); 
DataList_new_product.DataSource=(alltrip.SQL_SelectSQL_DataSet("select top 6 * from tripproduct  order by id desc","tripproduct")).Tables["tripproduct"]; 
DataList_new_product.DataBind(); } 
} 
可以看到，上面红色字体的Database和SQL_SelectSQL_DataSet类都是自己编写的。
代码如下：
public class Database
    {
        private string m_SqlConn;
        public Database(string p_SqlConn)
        {
            m_SqlConn = p_SqlConn;
        }        public DataSet SQL_SelectSQL_DataSet(string p_SqlSelectComm, string p_ScrTable)
        {            DataSet _ReturnDataSet = new DataSet();
            try
            {
                SqlDataAdapter _SqlDataAdapert = new SqlDataAdapter(p_SqlSelectComm, m_SqlConn);
                _SqlDataAdapert.Fill(_ReturnDataSet, p_ScrTable);
            }
            catch
            {
            }
            return _ReturnDataSet;
        }
        public int SQL_SelectSQL_Count(string p_SqlSelectComm)
        {            DataSet _ReturnDataSet = new DataSet();
            try
            {
                SqlDataAdapter _SqlDataAdapert = new SqlDataAdapter(p_SqlSelectComm, m_SqlConn);
                _SqlDataAdapert.Fill(_ReturnDataSet, p_ScrTable);
            }
            catch
            {
            }
            return _ReturnDataSet;
        }
    }
下面问题来了，我现在缺了这两个方法（红色部分）的代码，哪位好心人能帮我补上。1、allcity.SQL_SelectSQL_Count("select count(*) from tripproduct where endaddressarea='"+DataBinder.Eval(Container.DataItem, "area").ToString()+"' and leaveaddress='"+mid+"'")
2、
Database allproduct=new Database(ConfigurationSettings.AppSettings["数据库路径"]);
product.DataSource=(allproduct.SQL_SelectSQL_DataSet("select * from tripproduct where id="+Request["id"] ,"tripproduct")).Tables["tripproduct"].DefaultView;
mydata=allproduct.SQL_SelectSQL_Reader("select * from pubproduct where blong_city='"+ Request["city"]+"'");

Answer 1

 1 public int SQL_SelectSQL_Count(string p_SqlSelectComm)
        {       
            try
            {
                DataTable _Table = new DataTable();
                SqlDataAdapter _SqlDataAdapert = new SqlDataAdapter("SELECT Count(*) FROM (" + p_SqlSelectComm + ") RowNumb", m_SqlConn);
                _SqlDataAdapert.Fill(_Table);
                if (_Table.Rows.Count == 0 || _Table.Rows[0][0].ToString().Trim() == "") return 0;                return Convert.ToInt32(_Table.Rows[0][0].ToString());
            }
            catch
            {
            }
            return 0;
        }看方法的名字 像是返回查询语句返回的数据行数2        public SqlDataReader SQL_SelectSQL_Reader(string p_SqlSelectComm)
        {
            try
            {
                SqlConnection _SqlConn = new SqlConnection();
                _SqlConn.Open();
                SqlCommand _SqlCommand = new SqlCommand(p_SqlSelectComm, _SqlConn);
                return _SqlCommand.ExecuteReader();
            }
            catch
            {
                return null;
            }            
        }返回个SqlDataReader  看看把  你应该把返回数据类型帖出来.

Answer 2

        public int SQL_SelectSQL_Count(string p_SqlSelectComm)
        {            DataSet _ReturnDataSet = new DataSet();
            try
            {
                SqlDataAdapter _SqlDataAdapert = new SqlDataAdapter(p_SqlSelectComm, m_SqlConn);
                _SqlDataAdapert.Fill(_ReturnDataSet, p_ScrTable);
            }
            catch
            {
            }
            return _ReturnDataSet.Table[p_ScrTable].Count;
        }//***************************return DataSet****************************
        public DataSet SQL_SelectSQL_Reader(string p_SqlSelectComm)
        {            DataSet _ReturnDataSet = new DataSet();
            try
            {
                SqlDataAdapter _SqlDataAdapert = new SqlDataAdapter(p_SqlSelectComm, m_SqlConn);
                _SqlDataAdapert.Fill(_ReturnDataSet, p_ScrTable);
            }
            catch
            {
            }
            return _ReturnDataSet;
        }
//*********************重载1  return DataTable**************************** 
        public DataTable SQL_SelectSQL_Reader(string p_SqlSelectComm)
        {            DataSet _ReturnDataSet = new DataSet();
            try
            {
                SqlDataAdapter _SqlDataAdapert = new SqlDataAdapter(p_SqlSelectComm, m_SqlConn);
                _SqlDataAdapert.Fill(_ReturnDataSet, p_ScrTable);
            }
            catch
            {
            }
            return _ReturnDataSet.Table[p_ScrTable];
        }