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

[tiktak001]

我现在有一个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"]+"'");

[格拉]

自己动手,楼下接

[PandaIT]

看来真把程序员当民工了！

闪！

[ZJ159]

ding

[zgke]

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 看看把 你应该把返回数据类型帖出来.

[tiktak001]

不想回答可以不用回复

[PandaIT]

[Quote=引用 5 楼 tiktak001 的回复:]
不想回答可以不用回复
[/Quote]

你把你当成什么了？

[teerhu]

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];
}

[stonehy520]

自己写