Entries for trisonics

Crystal Report Problem showing Y value [Crystal Report Problem showing Y value]

trisonics — Fri, 01 Aug 2008 08:39:22 GMT

I am trying to show outstanding amount for each customer in a bar graph using crystal report. X axis showing customer and Y showing the outstanding amount.

For that I have created a DataSet object with a table and 2 columns(X(sting) and Y(double)) in my project and the crystal report datasource is defined as this dataset.

In the form I am fetching the data from database in a datatable assigning it as the source for the chart as below

CRBarChart crRptChart = new CRBarChart();
crRptChart.SetDataSource(<dataTable>);
crvChart.ReportSource = crRptChart;

The chart is coming with X axis as the customer but the Y value for all the customers is displayed as 1.

I have checked the datatable have values for the outstanding column also. but why its not being displayed in the chart?

Can anyone help

in reply to Crystal Report Problem showing Y value

Populate tab in asynchronous mode using AJAX [Populate tab in asynchronous mode using AJAX]

trisonics — Wed, 07 May 2008 10:21:46 GMT

Hi,

This might be bit naïve to many but I am new to AJAX so pardon me.

In my web application(asp.net,c#) I have 5 tab. Each tab has multiple elements. To populate data I have to call a backend procedure for this I will use AJAX. But the whole operation will take quite some time as there are many data elements.

My question is it possible to populate each tab separately. I.e. call separate procedure one after the other in a asynchronous mode and populate each table separately. So that the user doesn’t have to wait for the whole loading process to finish before he can see anything. This way he can see the details tab by tab.

It will be very helpful if you can post some sample.

thanks

in reply to Populate tab in asynchronous mode using AJAX

Simulating Oracle Form "POST" in .NET [Simulating Oracle Form "POST" in .NET]

trisonics — Thu, 29 Nov 2007 10:04:52 GMT

I am in process for converting a oracle form application with oracle backend to .net front-end and oracle backend.
Basically only the front-end from will become ASP.NET page the backend remaining the same and ODP.NET for database access.
Although I am not a forms developer but I can see that the form's "post" option is a very useful functionality. For db validation etc
Can anyone tell me how to achieve the same in a .net application programmatically.

Thanks

in reply to Simulating Oracle Form "POST" in .NET

Upgrading from ODP.NET 9.2 to 10.2 [Upgrading from ODP.NET 9.2 to 10.2]

trisonics — Wed, 05 Sep 2007 03:39:13 GMT

HI,

We are thinking of upgrading the ODP.NET version in our application from 9.2 to 10.2. During my research I found out there are some issues related to this e.g.

http://daveclarkesblog.blogspot.com/2007/03/upgrading-projects-from-odpnet-92-to.html

http://forums.oracle.com/forums/thread.jspa?threadID=423787

Is there anyone who has done the upgrade and let me know how rough the ride will be.

Also it will be nice to list out the issues/problems.

Thanks

in reply to Upgrading from ODP.NET 9.2 to 10.2

Type.GetType returning null [Type.GetType returning null]

trisonics — Wed, 29 Aug 2007 08:13:57 GMT

I have a windows forms project in VS 2003 which I migrated to VS 2005 after migration I found out that the following code does not work after migration

using System;

using

System.Drawing;

using

System.Collections;

using

System.ComponentModel;

using

System.Windows.Forms;

using

System.Data;

using

System.Reflection;

......

private

void OpenForm(string strName)

{

....

string strModName = "FX.FORM.UI.REPORT.FRMRPT"; // this just an eample the value is fetched from the database

Form objCurrFrm = (Form) Activator.CreateInstance(Type.GetType(strModName)); <--fails

objCurrFrm.GetType().InvokeMember("Show",BindingFlags.Default |BindingFlags.InvokeMethod,null,objCurrFrm,new object[]{});

....

}

......
.....

this is becaue Type.GetType is returning null.

I tried using the Assembly.GetTyp but I am getting an error as "Cannot load file or assembly ... or one of its dependencies"

But if I directly do

Form objCurrFrm = new FX.FORM.UI.REPORT.FRMRPT();

It works fine.

Iin my solution I have a login form which is a seperate project. This project has ref. to the main project which biuld the menu etc and rest of each are seperate project like sub project of the main all this individual project are being ref. by the main project.

After the login in successful the main project is loaded. This has the menu which is built from the database the dll names are fetched from the database. Once the menu is clicked the corrosponding dll has to be loaded.

Does anyone has any idea how to solve it.

in reply to Type.GetType returning null

Export screen in pdf format in VS 2005 (crystal report ) [Export screen in pdf format in VS 2005 (crystal report )]

trisonics — Tue, 07 Aug 2007 02:28:21 GMT

I am developing a web application in VS 2005 (C#). This is a combination of data entry and reporting. The screen is an exact copy of a printed form. The users can insert/update/delete details. Also there is option to export the screen in pdf format. This pdf should be exact copy of the screen.

I am thinking of using crystal report (VS 2005) for this purpose for easy export of data. But I am not sure how to allow editing of report document. Also I don’t want have the form template in 2 different place one for HTML and one in report for exporting data.

Can anyone advice on how to achieve the above in an efficient manner. A sample will be very helpful.

Thanks

in reply to Export screen in pdf format in VS 2005 (crystal report )

Migration Strategy for winforms from VS 2003 to VS 2005 [Migration Strategy for winforms from VS 2003 to VS 2005]

trisonics — Thu, 19 Jul 2007 10:00:57 GMT

I have a smartclient enterprise application developed in VS 2003 and plan to migrate it to VS 2005. Can any one point to some good resource on this regard

thanks

in reply to Migration Strategy for winforms from VS 2003 to VS 2005

convert dataset to excel for download in asp.net [convert dataset to excel for download in asp.net]

trisonics — Thu, 12 Apr 2007 09:54:28 GMT

I am having asp.net page where I have data. On the click of a
button the data in the dataset need to be downloaded on the client in excel format.
I donot want to have a postback for doing this as the data is already on the page.

can anyone help?

in reply to convert dataset to excel for download in asp.net

manipulating TreeView using javascript [manipulating TreeView using javascript]

trisonics — Tue, 21 Nov 2006 03:37:41 GMT

I am using a TreeView control with checkbox in my asp.net page. I am unable to get the value of the checked nodes using javascript.

Does anyone has any ideas on how to do this.

Any help will be appreciated.

Thanks

in reply to manipulating TreeView using javascript

refresh control value before postback [refresh control value before postback]

trisonics — Tue, 07 Nov 2006 09:05:25 GMT

hi

I am using postback in asp.net page to get data from the database.

public

void RaiseCallbackEvent(string eventArgument)
        {
            try
            {
                iniData(txtCode.Text);
            }
            catch (Exception Ex)
            {
               ....
            }
        }

initData takes a paramenter which the value of a code field on the page. The problem is txtCode.Text always reflects the old value.

Can anyone suggest how can I trap the new value the user enters and pass it.

thanks

in reply to refresh control value before postback

timeout [timeout]

trisonics — Wed, 02 Aug 2006 08:06:25 GMT

Hi

I have a application in windows form. The application generates graphs using crystal reports based on input criterias.

Most of the time I am encountering execution timeout error. As the data volumne is large.

I have client side webservice timeout as,

svc1.svc mysvc =

new svc1.svc();
mysvc.timeout = 1200000

IIS server session timeout as 30 min

and in the web.config I have

<add key="DSN" ...Min Pool Size=2;Connection Lifetime=1800;Connection Timeout=900;Incr Pool Size=2; Decr Pool Size=2" />

I want to know what is max value for the 3 timeouts.

regards,

in reply to timeout

opening an rtf file from webserver in a richTextBox [opening an rtf file from webserver in a richTextBox]

trisonics — Thu, 18 May 2006 06:29:59 GMT

Hi,

I want to open an .rtf/.doc file residing on the webserver inside a richTextBox in a windows form.

The problem is if I do
richtextbox1.LoadFile("http://servername/doc/test.rtf");

It is showing an error
"URI formats are not supported."
Does anyone has any idea on how to solve it.

thanx

in reply to opening an rtf file from webserver in a richTextBox