Recent content by Matsul

Is there a way of disabling the running totals in an excel pivot table ? Pivot ----- Sum of Count Total MM a 30 MM Total 30 --> Not Required PP a 10 d 10 PP Total 20 --> Not Required RM a 50 d 30 RM Total 80 --> Not Required Grand Total 130 Data (to create above pivot)...

I am exporting a grid view to excel using the the code as below; using System; using System.Data; using System.Configuration; using System.IO; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using...

I am doing private DataTable CreateDataTable() { DataTable myDataTable = new DataTable(); DataColumn myDataColumn; myDataColumn = new DataColumn(); myDataColumn.DataType = Type.GetType("System.String"); myDataColumn.ColumnName =...

How can I set a string as follows string mm="amt (€)"; ? When I display I am getting amt (€) thanks for any help.

That would be the sysdate, while I need a constant which is a date. thx, Matt

Hi Mufasa, the thing is I have to load data from files having a date in the file name (MM_20090309_EXEC_2.csv) and need to have the date in the name as one of the entries. So I used sed in Unix to change the controlfile to the date and need to load hope to load it as a constant. I have a...

I need to load a date as a constant into a table. I tried; LOAD DATA APPEND INTO TABLE "HLR_OWNER"."FOR" FIELDS TERMINATED BY ',' (MS, IM, Filedate "to_date('20090309','YYYYMMDD')" ) but I get; Record 1: Rejected - Error on table "FOR", column FILEDATE. Column not found before end of logical...

I need to pass a parameter having an * representing a list of files >touch mm1 >touch mm2 emacs tt.ksh FF=mm* echo call $FF >chmod u+x tt.ksh > ./tt.ksh call mm1 mm2 How can I display call mm* ? thx

I have a method public List<string> getMList() { List<string> listM=null; listContracts.ForEach(delegate(Cobj contract) { listM.Add(contract.M); }); return (listM); }...

Using Visual Studio 2005, c# I have in Source view; <td style="width: 193px; height: 31px;"> Name </td> <td style="width: 327px; height: 31px"> <asp:TextBox runat="server" ID="txtName" AutoPostBack="true"...

I tried HttpContext.Current.Response.Charset = "UTF-16"; (as below) and some others but still no luck. thanks. public class GridViewExportUtil { /// <summary> /// /// </summary> /// <param name="fileName"></param> /// <param...

Exporting to excel (VS 2005 .Net c#), I am having problems with the €. 10660 56660 € 158,58 € 158,58 is becoming 10660 56660 € 158,58 € 158,58 It is the footer of a grid, extracted using if (gv.FooterRow != null) {...

Hi Mufasa, all, I want to have two SQL programs; 1. Loads array into memory and passes the array to program 2. 2. Performs processing on the array So that in SQL I run say; SQL> @load_array SQL> @process_array So how can I define the array such that process_array can see what was loaded...

I have a script that loads a huge array. Kind of Declare PROCEDURE pLoadArray (vaCustcode_num IN OUT vacustcodednno) IS iarraysize INTEGER := 3000; i INTEGER; vErrorMessage VARCHAR2 (256) := ''; BEGIN FOR i IN 1 .. iarraysize LOOP...

I need to use in xls v2003 the option; Edit --> Fill --> Series for some reason Series is shaded and cannto be selected. Down , Right , Up, Left and Justify are not shaded. If I start a blank worksheet it works so I am having to make series on a blank worksheet and paste them in. Any help...