C# Discussion Boards - CodeProject

style button

toba tavasoli31-May-10 5:09

toba tavasoli

31-May-10 5:09

example ebout style button

Re: style button

OriginalGriff31-May-10 5:12

OriginalGriff

31-May-10 5:12

question

See how annoying that is?

Do you have a question?
Read the instructions at the top of the page "how to get an answer to your question".
Then edit your post to comply. Then, maybe, you will get help.

Did you know:
That by counting the rings on a tree trunk, you can tell how many other trees it has slept with.

Re: style button

Abhinav S31-May-10 6:00

Abhinav S

31-May-10 6:00

See here. This will help you ask a question so that you can get an answer.

My signature "sucks" today

Re: style button

Smithers-Jones31-May-10 8:07

Smithers-Jones

31-May-10 8:07

Don't you know, how to phrase a complete sentence?

"I love deadlines. I like the whooshing sound they make as they fly by." (DNA)

Speed Issue in POS Customer Display

NetMan201231-May-10 4:34

NetMan2012

31-May-10 4:34

Hello,

I have developed an point of sale desktop application. I have integrated the Customer Display too with this app. Now i am facing a little issue, When ever Customer display writes some thing on it, it takes around 3 seconds to write always whatever i write, 3 Seconds is too much and its slowing down the speed of app. ANy suggestions..?

Re: Speed Issue in POS Customer Display

Luc Pattyn31-May-10 4:51

Luc Pattyn

31-May-10 4:51

tell us more about the "Customer Display". Is it a commercial product? what is the interface (hardware and software)? is there a handshake protocol involved? maybe show relevant code (inside PRE tags!).

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]

I only read formatted code with indentation, so please use PRE tags for code snippets.

I'm not participating in frackin' Q&A, so if you want my opinion, ask away in a real forum (or on my profile page).

Re: Speed Issue in POS Customer Display

Alan Balkany1-Jun-10 3:50

Alan Balkany

1-Jun-10 3:50

The first step is to time the different steps of the process to identify which is taking the most time. Often the bottleneck isn't where you suspect it is.

Only after you know what's slowing down the process can you start to correct it.

stringbuilder to string

michaelgr131-May-10 1:22

michaelgr1

31-May-10 1:22

Hello,

When i am trying to copy stringbuilder to string it copies the same string twice or 3 times
for example if i do:

stringbuilder temp=new stringbuilder();
string temp1;
temp1=temp.tostring();

if temp="abc";
then temp1 gets- "abcabcabc"

why is that?

Re: stringbuilder to string

Rajeshwar Code- Developer31-May-10 1:31

Rajeshwar Code- Developer

31-May-10 1:31

Try !ispostback

try and try untill reach success..

Re: stringbuilder to string

michaelgr131-May-10 1:32

michaelgr1

31-May-10 1:32

how do i use it?

Re: stringbuilder to string

Not Active31-May-10 2:34

Not Active

31-May-10 2:34

IsPostback is relevant to ASP.NET. The OP did not say what environment he was using so your answer could be completely irrelevant and worse misleading.

I know the language. I've read a book. - _Madmatt

Re: stringbuilder to string

Not Active31-May-10 2:35

Not Active

31-May-10 2:35

You haven't shown any code that actually adds values to the stringbuilder. Where is that? Are you calling it multiple times perhaps.

I know the language. I've read a book. - _Madmatt

Re: stringbuilder to string

michaelgr131-May-10 2:46

michaelgr1

31-May-10 2:46

I fount my mistake.
I had a method that returns a stringbuilder and receives a stringbuilder.
for example:

private stringbuilder method1(stringbuilder temp)
{
temp.append("abc");
}

private void main_method()
{
stringbuilder main=new stringbuilder();
main.append(method1(main));
}

something like that

Re: stringbuilder to string

#realJSOP1-Jun-10 4:56

#realJSOP

1-Jun-10 4:56

michaelgr1 wrote:
if temp="abc";

Hmmmm....

Show us as much of the actual associated code as you can...

.45 ACP - because shooting twice is just silly
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001

DataAdaptor.Fill startRecord

Eli Nurman31-May-10 1:18

Eli Nurman

31-May-10 1:18

Hi. i have been wondering for a while, is there any option to retrieve rows from a SQL Server with a startRecord e.g. select top 20 records from position 25, Without any WHERE conditions (without WHERE ID > 25)..

Please advice.

Thanks

Re: DataAdaptor.Fill startRecord

Rajeshwar Code- Developer31-May-10 1:34

Rajeshwar Code- Developer

31-May-10 1:34

I think there a one way to do this

Retrive all data columns and fill it into dataset and loop it.

try and try untill reach success..

How to call from an unmanaged DLL to managed code

Keith Vitali31-May-10 0:53

Keith Vitali

31-May-10 0:53

Hello,

I currently have an unmanaged DLL written in C++ and I can call the exported methods in this DLL from my C# app without any problems and it works quite well.

Now, I need to call from this DLL a method in my managed app. Is it possible to do so? What do I need to do so that the managed method is visible and available to the unmanaged DLL?

Thanks,

Keith

Re: How to call from an unmanaged DLL to managed code

Abhinav S31-May-10 1:10

Abhinav S

31-May-10 1:10

See this article.

My signature "sucks" today

Re: How to call from an unmanaged DLL to managed code

Luc Pattyn31-May-10 1:53

Luc Pattyn

31-May-10 1:53

or look at "delegates" and "two-side logging" in this article[^].

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]

I only read formatted code with indentation, so please use PRE tags for code snippets.

I'm not participating in frackin' Q&A, so if you want my opinion, ask away in a real forum (or on my profile page).

programmatically export crystal report with a sub report to .doc file

MayukhSen30-May-10 23:51

MayukhSen

30-May-10 23:51

Hi!.
I have a report containing a link to view subreport . Now i have to export that in .doc programmatically. I am able to do this . But the subreport is not exported. How to export the report with the subreport.

Thanks

Help ploting Excel graph in C#

Mc_Topaz30-May-10 23:17

Mc_Topaz

30-May-10 23:17

I have the current data in an excel sheet:

<br />
---A---B---C--<br />
1| 0 | 5 | 1 |<br />
2| 2 | 4 | 2 |<br />
3| 4 | 3 | 3 |<br />
4| 6 | 2 | 4 |<br />
5| 8 | 1 | 5 |<br />
<br />

The values for column A and B are the Y-axis values for two lines in the graph. The C column is the X-axis values which both lines shares.

I would like to create a graph containing two lines based on the data above. I don't understand how to do that. The guides on internet are to general and don't deal with this case.

I have come with this method to plot the graph in the active worksheet.
The "workSheet" object is the active work sheet in my C# application.

public void TestAddChart(XlChartType type, System.Drawing.Point location, Size size)
{
      ChartObjects chartObjects = (ChartObjects)workSheet.ChartObjects(Type.Missing);
      ChartObject chartObject = chartObjects.Add(location.X, location.Y, size.Width, size.Height);
      Chart chart = chartObject.Chart;

      Range line1Yvalues = workSheet.get_Range("A1", "A5");
      Range line2Yvalues = workSheet.get_Range("B1", "B5");
      Range commonXvalues = workSheet.get_Range("C1", "C5");

      chart.SetSourceData(line1Yvalues, XlRowCol.xlRows);
      chart.SetSourceData(line2Yvalues, XlRowCol.xlRows);
      chart.SetSourceData(commonXvalues, XlRowCol.xlRows);
}

I call the method with this code:

classInstance.TestAddChart(XlChartType.xlLine, new Point(100, 100), new Size(300, 300));

When I shut down my application and look in the excel file, I find the result of the graph to be something else. There is instead a bar chart containing five series.

What shall I change to make this work?

Re: Help ploting Excel graph in C#

OriginalGriff30-May-10 23:29

OriginalGriff

30-May-10 23:29

Perhaps the place to start would be using the "type" parameter somewhere in your method?

Did you know:
That by counting the rings on a tree trunk, you can tell how many other trees it has slept with.

Re: Help ploting Excel graph in C#

Mc_Topaz30-May-10 23:51

Mc_Topaz

30-May-10 23:51

Yes of course, forgot that one D'Oh! | :doh:

Here is the correed version of the method:

public void TestAddChart(XlChartType type, System.Drawing.Point location, Size size)
{
    ChartObjects chartObjects = (ChartObjects)workSheet.ChartObjects(Type.Missing);
    ChartObject chartObject = chartObjects.Add(location.X, location.Y, size.Width, size.Height);
    Chart chart = chartObject.Chart;

    Range line1Yvalues = workSheet.get_Range("A1", "A5");
    Range line2Yvalues = workSheet.get_Range("B1", "B5");
    Range commonXvalues = workSheet.get_Range("C1", "C5");

    chart.SetSourceData(line1Yvalues, XlRowCol.xlRows);
    chart.SetSourceData(line2Yvalues, XlRowCol.xlRows);
    chart.SetSourceData(commonXvalues, XlRowCol.xlRows);
    chart.ChartType = type;
}

But the result is still not what I wanted. Here is the new result:

1) No lines in the graph is visible
2) There are five series, it should only be two
3) The Y-axis value is from 0 to 6, it should at least be 0 to 8.
4) The x-axis value is just 1, it should be 1 to 5.

I guess Excel cannot figure out that Line1 and Line2 should share same X-axis values. Or I lack those instructions.

What to do now?

Re: Help ploting Excel graph in C#

Henry Minute31-May-10 0:37

Henry Minute

31-May-10 0:37

I have never used c# to access/modify Excel and so do not have a definitive answer to your problem.

However, in this part of your code

chart.SetSourceData(line1Yvalues, XlRowCol.xlRows);
chart.SetSourceData(line2Yvalues, XlRowCol.xlRows);
chart.SetSourceData(commonXvalues, XlRowCol.xlRows);
chart.ChartType = type;

I notice that all three data sources are set to XlRowCol.xlRows, which seems odd to me. Shouldn't, at least, one of them be set to XlRowCol.xlColumns?

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
Why do programmers often confuse Halloween and Christmas?
Because 31 Oct = 25 Dec.

Re: Help ploting Excel graph in C#

Mc_Topaz31-May-10 1:10

Mc_Topaz

31-May-10 1:10

Oh yes, you maybe right. I thought the XlRowCol specified how excel should read the data in the sheet. Guess I was wrong.
Anyway I changed commonXvalues's XlRowCol-value from "XlRowCol.xlRows" to "XlRowCol.xlColumns" in the SetSourceData() method call.

The final result is almost what I want. Here is the major issue:

Only one line is displayed. It seems that the line's data is taken from the C column only. That's not what I wanted.

It seems hard to plot two line with this configuration:
* Line 1 Y-axis data from line1Yvalues range and X-axis data from commonXvalues range.
* Line 2 Y-axis data from line2Yvalues range and X-axis data from commonXvalues range.

Here is yet again the corrected version of the method:

public void TestAddChart(XlChartType type, System.Drawing.Point location, Size size)
{
     ChartObjects chartObjects = (ChartObjects)workSheet.ChartObjects(Type.Missing);
     ChartObject chartObject = chartObjects.Add(location.X, location.Y, size.Width, size.Height);
     Chart chart = chartObject.Chart;

     Range line1Yvalues = workSheet.get_Range("A1", "A5");
     Range line2Yvalues = workSheet.get_Range("B1", "B5");
     Range commonXvalues = workSheet.get_Range("C1", "C5");

     chart.SetSourceData(line1Yvalues, XlRowCol.xlRows);
     chart.SetSourceData(line2Yvalues, XlRowCol.xlRows);
     chart.SetSourceData(commonXvalues, XlRowCol.xlColumns);
     chart.ChartType = type;
}

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.