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); }
private void CreateAdapter() { baseClassAdapter = new BaseAdapter(); baseClassAdapter.TableMappings(tableName, tableName); }