public DataSet SelectPartial(string from, string fields, string filter, int start, int limit, string orderBy, out int totalRecords) { BaseCommand cmn = new BaseCommand(MsConn); cmn.CommandType = System.Data.CommandType.StoredProcedure; cmn.CommandText = "GetPartialData"; cmn.Command.Parameters.AddWithValue("tableName", from); cmn.Command.Parameters.AddWithValue("fields", fields); cmn.Command.Parameters.AddWithValue("filter", filter); cmn.Command.Parameters.AddWithValue("start", start); cmn.Command.Parameters.AddWithValue("limit", limit); cmn.Command.Parameters.AddWithValue("orderby", orderBy); cmn.Command.Parameters.Add("totalRecords", SqlDbType.Int); cmn.Command.Parameters["totalRecords"].Direction = ParameterDirection.Output; cmn.Command.CommandType = CommandType.StoredProcedure; if (baseClassAdapter != null) { baseClassAdapter.Dispose(); } baseClassAdapter = new BaseAdapter(); baseClassAdapter.SelectCommand = cmn.Command; baseClassAdapter.TableMappings(tableName, tableName); DataSet Data = new DataSet(); baseClassAdapter.Fill(Data, tableName); totalRecords = (int)cmn.Command.Parameters["totalRecords"].Value; return(Data); }
public void Dispose() { GC.SuppressFinalize(this); if (_baseAdapter != null) { _baseAdapter.Dispose(); } //şimdilik kapatma, application_endrequest kapatsın bakalım. //MsConn.Close(); }