第一次碰到了通过ADODB去连接数据库。所以就把连接做个记录~~~~ ADODB.Connection Conn = new ADODB.Connection(); ADODB.Recordset Rs = new ADODB.Recordset(); Rs.CursorLocation = ADODB.CursorLocationEnum.adUseClient; //设置为客户端属性 Rs.CacheSize = 1; bool bolOut = true; string DBStr = ""; DBStr = "Driver={SQL Server};Server=127.0.0.1;Database=northwind;Trusted_Connection=yes"; Conn.Open(DBStr, "sa", "sasa", -1); Rs.Open(Sql, Conn, (ADODB.CursorTypeEnum)1, (ADODB.LockTypeEnum)1, -1); if (Rs.EOF) //判断数据是否存在 不存在返回true 存在返回false { bolOut = false; } Rs.Close(); Conn.Close(); Rs = null; Conn = null; /**************************************/ //取某页的记录 MianInfo[] info = { }; Rs.Open(String.Format("select oid,* from maininfo where {0} {1} limit {2} of