＋设为首页 ＋添加到收藏夹
namespace dataproxy{ /// <summary> /// 说明: 本类主要实现对数据库的操作(查询|sp) /// 建立者: 黄宗银 /// 建立时间: 2004-12-4 /// </summary> public class dataproxy { #region 读取数据 /// <summary> /// 从数据库查询数据 /// </summary> /// <param name="rowscount">返回最 top 的记录数</param> /// <param name="columns">查询列名</param> /// <param name="target">查询目标</param> /// <param name="condition">查询条件</param> /// <param name="orderby">排序</param> /// <param name="connect">连接字符串</param> /// <param name="ex">异常信息</param> /// <returns>查询结果</returns> public static dataset getdbdata( int rowscount, string columns, string target, string condition, string orderby, string connect, ref string ex ) { ex = string.empty; sqlconnection sqlconnection = new sqlconnection( connect ); try { string[] arrcolumns = columns.split( , ); string strquery = "select top " + rowscount + " " + ((arrcolumns[0].trim() == "*") ? " *" : " [" + arrcolumns[0].trim() + "]"); for( int i = 1; i < arrcolumns.length; i++ ) { strquery += ", [" + arrcolumns[i].trim() + "]"; } strquery += " from [" + target + "]"; if( condition != null && condition.trim() != string.empty ) { strquery += " where " + condition; } 【推荐阅读:在VB6中动态创建使用ADO控件访问数据】
using system;using system.data;using system.data.sqlclient;
... 下一页