日期:2014-05-18 浏览次数:21188 次
        //查询语句
        public DataSet GetBSF(string BSF)
        {
            return data.RunProcReturn("select * from tb_Main where bsf='" + BSF + "'", "tb_Main");
        }
        /// <summary>
        /// 执行命令文本,并且返回DataSet数据集
        /// </summary>
        /// <param name="procName">命令文本</param>
        /// <param name="tbName">数据表名称</param>
        /// <returns>DataSet</returns>
        public DataSet RunProcReturn(string procName, string tbName)
        {
            SqlDataAdapter dap = CreateDataAdaper(procName, null);
            DataSet ds = new DataSet();
            dap.Fill(ds, tbName);
            this.Close();
            //得到执行成功返回值
            return ds;
        }