Excel chart in c# - C# Discussion Boards

Possibly a firewall or antivirus blocking the required port on the clients or the router blocking that port if they are behind one?

Dave

HI

Hi,

I have developed a C#.net windows application and in that one i have used a third party control in it..

For deploying the application i am publishing my application so a setup.exe file is getting created
When i installed it at client side its working fine

My question is ...Why in the Client System ...my system name is appearing ...How to change it

Execution path in client system
start...programs.......my system name...application name

i want to replace that one with some other name

EX :
Present
start.....programs.....Happy...WindowsApplication1

want to change to

start.....programs....Softy.....WindowsApplication1

Plz reply me how to do this

regards sindhu tiwari

its me sid

Because you built the installer that way. What are you using to make an MSI ?

Christian Graus - Microsoft MVP - C++

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

What i am doing is just right click on the project then i have clicked publish there .............

i am using Visual studio 2005 professional edition
regards
sindhu tiwari

its me sid

OK, I presume it's assuming that you are the author and want a group created. If there are no options presented, you'll need to use a different tool, like Advanced Installer.

Christian Graus - Microsoft MVP - C++

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

Hi,

I have developed a C#.net windows application and in that one i have used a third party control in it..

For deploying the application i am publishing my application so a setup.exe file is getting created
When i installed it at client side its working fine

My question is ...Why in the Client System ...my system name is appearing ...How to change it

Execution path in client system
start...programs.......my system name...application name

i want to replace that one with some other name

EX :
Present
start.....programs.....Happy...WindowsApplication1

want to change to

start.....programs....Softy.....WindowsApplication1

Plz reply me how to do this

its me sid

hi,
I do not succeed in allocating a value for the axle x in my graph. I do not succeed in finding correspondence with there vb seriecollection (1) .XValue =
help me i begin in C#!!!!

public void Excel_Graphic(int Lig, int col)
{
string upperLeftCell = "A3";
int endRowNumber = System.Int32.Parse(upperLeftCell.Substring(1))
+ Lig - 1;
char endColumnLetter = System.Convert.ToChar(
Convert.ToInt32(upperLeftCell[0]) + col - 1);
string upperRightCell = System.String.Format("{0}{1}",
endColumnLetter, System.Int32.Parse(upperLeftCell.Substring(1)));
string lowerRightCell = System.String.Format("{0}{1}",
endColumnLetter, endRowNumber);

Worksheet ws = (Worksheet)app.ActiveSheet;

Object Graph1 = new Object();

ChartObjects GraphObjs = (ChartObjects)ws.ChartObjects(Type.Missing);
ChartObject GraphtObj = GraphObjs.Add(100, 20, 300, 300);

Chart xlChart = GraphtObj.Chart;

Range chartRange = ws.get_Range("A2", lowerRightCell);
Range AxeY = ws.get_Range("A2", "A16");
Range AxeX = ws.get_Range("B2", "B16");

xlChart.SetSourceData(AxeY, Type.Missing);
xlChart.ChartType = XlChartType.xlXYScatterLines;
xlChart.Location(XlChartLocation.xlLocationAsNewSheet, Graph1);
}

jere

HI All,
I have written a FOREACH loop to get results .Here it is.
foreach(NFConsolG lobjcongds in lobjCons.GList)
{

if(lobjcongds.Status==1)
{
try
{
lobjcongds.ConName=lobjCon1.TradingName;

units=this.GetPublish1(sc,lobjcongds);

if(units!=null && units.Length>0 && units[0]!=null && units[0].GetType().Equals(typeof(Unit)))
{
UnitArrayList.AddRange(units);

}
}
catch{}
}

}

I need to call this.GetPublish1() method using Threads.But it is inside a loop. Is there a way to use Threads for this FOREACH loop?

Please advice me.

You can start a thread for each object, if you want to access the threads later from the main thread, just store them in a list.

Christian Graus - Microsoft MVP - C++

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

A couple of observations:
1. If you return a value from a method you call in a different thread, your calling method might be long gone by the time your called method completes execution. You will have to rethink your design.
2. If there are many items in your collection, you might end up spawning a huge number of threads. This is not a very good idea.

Cheers,
Vikram.

"The weak can never forgive. Forgiveness is the attribute of the strong." - Mahatma Gandhi.

Hi friends,
When I was trying to execute one game project, following exception occured at runtime.

NoSuitableGraphicsDeviceException: Direct3D hardware acceleration is not available or has been disabled. Verify that a Direct3D-enabled graphics device is installed, and check the display properties to verify that Hardware acceleration is set to Full.

Please let me know to how to solve this exception. I already installed DirectX.

Thanks and Regards,
Lalitha.

Sounds like you don't have a card installed that uses DirectX and has an up to date driver and hardware acceleration turned on.

Christian Graus - Microsoft MVP - C++

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

Where can I get the card that uses DirectX. Please guide me to solve this.

Thanks and Regards,
Lalitha.

At the computer store ? Odds are very high you have one already, and just need to install the proper driver.

Christian Graus - Microsoft MVP - C++

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

I have a problem in converting ASCII extended characters in my C# program. I have already tried the following statement." System.Text.Encoding.Default.GetString(buff). buff is a byte array"
this statement does not show me the correct ASCII extended char.
Any body cam help out?

S.Jamman

modified on Thursday, February 14, 2008 5:14 AM

The default encoding is Unicode. Have you tried specifying ASCII directly ?

Christian Graus - Microsoft MVP - C++

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

yes I have specified directly to ASCII. Actually Windows does not show the appropriate extended character against the byte code. like 155=Ø in ASCII extended table. But my program shows the character against 155=>. I cannot understand why it is happening?

S.Akmal

Jamman wrote:
like 155=Ø in ASCII extended table. But my program shows the character against 155=>

As per the following site '>' is correct
ASCII Code - The extended ASCII table[^]

*jaans

Hi fellas,

i am working on a project that requires the application be be multi threaded in order to montior power and network events, i was trying add media player in to the application to do play and pause when the events occured, but when i added in media player ig o an error saying that it will only run on a single thread app, is there anywey around this or can somebody offer some help please

many thanks

hi all,

im doing this project using c# and asp.net in visual studio.

one question here,
i needed to check if it is the Header of the excel sheet telly my heading.
(how to read and check the excel heading from the first row?)
-- will do a check like.. A1 = code , B1 = name, C1 = Department

eg.

Excel:

| Code | name | Department |

thanks! Blush | :O

=D

hi can you give a few code to help you but i think if you know where are your informations you can use : worksheet.Cells[row, col]

jere

oh..

i use oledb connection to read..

string srcConnString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+ sourceFile + @";Extended Properties=""Excel 8.0;HDR=NO;""";

string srcQuery = "Select * from [" + GetExcelSheetNames(     sourceFile)[0] + "]";

hi...

can you explain your question in detail way . so that I can give you some more inputs.

Hi All,

I need to run 3 methods parallaly.Then I have used Threading for that. Here is the code.

public void threadtest()
{
Thread SpecialThread = new Thread(new ThreadStart(this.GetSpecial));
Thread BulkThread = new Thread(new ThreadStart(this.GetBulk));
Thread NormalThread = new Thread(new ThreadStart(this.GetNormal));

SpecialThread.Start();
BulkThread.Start();
NormalThread.Start();

SpecialThread.Join();
BulkThread.Join();
NormalThread.Join();

while((NormalThread.ThreadState==System.Threading.ThreadState.Running) ||
(BulkThread.ThreadState==System.Threading.ThreadState.Running) ||
(SpecialThread.ThreadState==System.Threading.ThreadState.Running)
)

{
}
}

But most of time one or two threads are going to aborted or something happen and I loose their results.Sometimes this worked properly and I can get all results from 3 methods.

Can any one correct this code?