在数据中统计记录行时用DataSet ds = new DataSet()

 后台代码：

    protected DataSet seSearch(string sql)

    {

        SqlDataAdapter Sqlcmd = new SqlDataAdapter(sql, conn);

        DataSet ds = new DataSet();

        Sqlcmd.Fill(ds, "mytable");

        return ds;

    }

    //存在BUG的最新版本ID号

    protected string Edition_ID(object strArgument)

    {

        int Num = 0;

        string pro_id = "";

        string sql = "select distinct bug_pro_id from bug where bug_sw_id='" + strArgument + "'" + sqlStr + " order by bug_pro_id desc";

        Num = seSearch(sql).Tables[0].Rows.Count;

        if (Num == 0) { pro_id = ""; } else { pro_id = seSearch(sql).Tables[0].Rows[0][0].ToString().Trim(); }

        return pro_id;

    }

    //存在BUG的版本个数

    protected string Edition_Num(object strArgument)

    {

        int Num = 0;

        //不能用cmd.ExecuteScalar()!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

        // ExecuteScalar()方法主要返回结果集中第一行第一列，通常利用它来获取聚合值。如Count(*)值。

        //SqlCommand cmd = new SqlCommand("select distinct bug_pro_id from bug where bug_sw_id='" + strArgument + "'", conn);

        //conn.Open();

        //E_Num = Convert.ToInt32(cmd.ExecuteScalar());

        //conn.Close();

        //return E_Num.ToString();

        string sql = "select distinct bug_pro_id from bug where bug_sw_id='" + strArgument + "'" + sqlStr + "";

        Num = seSearch(sql).Tables[0].Rows.Count;

        return Num.ToString();

    }