Re: Is there any API for powerpoint file programming in .net? - C# Discussion Boards

11-Oct-05 7:10

I wasn't being a jerk, hence me putting "I know you're just trying to help". I apologize for my post to you and retract what I said. What I am wondering though is why my post didn't show up on yours when it was a full hour before?? Perhaps the code project is running a little slow? In any case, my goal here is not to make enemies so I am truly sorry.

VB.NET IRR Function

zaboboa11-Oct-05 3:04

zaboboa

11-Oct-05 3:04

Hello,

Is there an equivelent IRR function in C#, to the one in VB? Does anyone knows of any resources, etc.. that will help me to write the IRR function in C#?

Thank you.

Re: VB.NET IRR Function

Dave Kreskowiak11-Oct-05 5:38

Dave Kreskowiak

11-Oct-05 5:38

You don't have to rewrite it and it's not part of Visual Basic.NET (the language anyway). It's part of the Microsoft.VisualBasic namespace, in the Financial class. Just set a .NET reference to the Microsoft.VisualBasic.dll and import the namespace.

If you really want the source code for the function, you can use Lutz Roeder's .NET Reflector to see the source in C# or VB.NET.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Re: VB.NET IRR Function

zaboboa11-Oct-05 9:45

zaboboa

11-Oct-05 9:45

Thanks, Great Help

How can I see the code using Lutz?

Thank you

Windows Service

Talktorajeev11-Oct-05 2:20

Talktorajeev

11-Oct-05 2:20

Hi folks,
Can any one guide me for a way to change "Startup Type" of windows service in runtime. Any pointer will be of great help.
Thanks in advance.
Regards
Rajeev

Re: Windows Service

XRaheemX11-Oct-05 3:18

Is there any API for powerpoint file programming in .net?

11-Oct-05 3:18

You can use the following article on the subject:

http://www.codeproject.com/csharp/ExtendServiceController.asp[^]

ting66811-Oct-05 2:18

ting668

11-Oct-05 2:18

Hi,

Is there any API for powerpoint file programming in .net? If using Office Interop assembly, is it necessary to install office in the system? Since i would like to implement a server for powerpoint file retrieval and do not like installing office in a server.

Thanks Smile | :)

Re: Is there any API for powerpoint file programming in .net?

David Stone11-Oct-05 7:26

David Stone

11-Oct-05 7:26

Yes, the Office PIA's require Office on the system that you're using them on.

And no, it doesn't look like there's any PPT SDK for .NET. Since you're building a server for "powerpoint file retrieval", is there a reason you're not just letting people download the PPT file via HTTP or FTP?

Picture a huge catholic cathedral. In it there's many people, including a gregorian monk choir. You know, those who sing beautifully. Then they start singing, in latin, as they always do: "Ad hominem..."
-Jörgen Sigvardsson

Re: Is there any API for powerpoint file programming in .net?

ting66812-Oct-05 1:50

ting668

12-Oct-05 1:50

Hello,

Of course, I would not like others downloading the powerpoint files from the server without the access right.

I heard from my friend office should not be installed on a server. Is it true? That means I cannot install office on the server so I cannot use the office interop assembly?

There is an alternative that I could turn a powerpoint file to an XML file. Is there any API for .net programming to do such thing? I have found a api call PowerML but it is a java library.

Thanks

Starter KIT Problem

Micu Radu11-Oct-05 1:59

Micu Radu

11-Oct-05 1:59

In VS2005 Beta the oersonal web kit is available, I have loaded and CTR+F5 the I closed the page and tryed to add a user as it says in the doc, the page is loaded and after I click the Security tab this error is shown:
"There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store.

The following message may help in diagnosing the problem: Exception has been thrown by the target of an invocation."

How can I FIX THIS?

"Tow things are infinite,
the Universe and human stupidity,
and I am not so sure about the former!"
Albert Einstein

Office Development BIG PROBLEM

Micu Radu11-Oct-05 1:59

Micu Radu

11-Oct-05 1:59

I have installed the Visual Studio 2003 FULL With MSDN (ORIGINAL NOT CRACKED Smile | :)

, Office 2003PRO FULL.
After installing Office i have insatlled the MSDE form OFFICE CD, IIS is installed.
Then: Microsoft Office Access 2003 Developer Extensions (English)
Microsoft Visual Studio® Tools for the Microsoft Office System 2003 (English)
Then: SQL SERVER 2000
Then: VS2005 Beta (Full install).
Now the problem is in 2003 when I try to create a Office Project it loads my prj then if I try to execute it Word is opening and after 1 sec it closes...

In 2005 after creating the proj and F5 the Word is Oppend and an error appears in VS:

FileNotFoundException was unhandled
"Could not load file or assembly 'WordDocument, Version=1.0.2110.20427, Culture=neutral' or one of its dependencies. The system cannot find the file specified."

If I close the VS and try to open the WordDOC it loads and an error appears:
"Office document customization is not available"
"The customization assembly could not be found or could not be loaded.
You can still edit and save the doc. Contact bla bla..."

PLS HELP ME I REALLY NEED IT TO WORK

"Tow things are infinite,
the Universe and human stupidity,
and I am not so sure about the former!"
Albert Einstein

Re: Office Development BIG PROBLEM

David Stone11-Oct-05 7:23

David Stone

11-Oct-05 7:23

There are some issues when using Visual Studio Tools for Office and .NET 2.0 at the same time. VSTO is very picky with respect to the runtime it uses. My recommendation would be to uninstall VS2005 or, to fire up a Virtual Machine (in Virtual PC, since you've got MSDN) and try installing just VS2003 and VSTO in it.

hide data grid columns

theStorminMormon11-Oct-05 1:53

theStorminMormon

11-Oct-05 1:53

I just want to hide some columns on my data grid (dynamically). I have my data grid, it's loading the data just fine, and all I want to do is make a column hidden.

Here's what I wrote:

this.dgClaimsExperience.Columns(1).Visible = false;

But C# tells me that System.Windows.Forms.DataGrid does not contain a definition for columns.

So... how do I do it?

Thanks.

The ends can never justify the means. It is the means that determine the ends.

Re: hide data grid columns

Wjousts11-Oct-05 2:36

Wjousts

11-Oct-05 2:36

DataGrid indeed does not contain a columns collection.
There are a couple of ways you can handle this, one way is to remove the DataGridColumnStyle for the column you want to hide from DataGrid.TableStyles. The tricky part is that if you want to put it back in it will move to the end of the list and you'll have to rearrange all the other columns (by removing them from the list and then adding them back in the right order).
Another way is to set the width of the column (through the DataGridColumnStyle) to zero, but I think the user can still resize it and I think it they can still tab to the column.

Re: hide data grid columns

theStorminMormon11-Oct-05 3:07

theStorminMormon

11-Oct-05 3:07

Thanks for the suggestions. I think removing the DataGridColumnStyle will work, because in the instance of the form where the data grid is located, I'm never going to want to add the column back in.

If you get a chance, post a code snippet for me, otherwise I'm sure I can figure it out on my own.

I'd just like to state for the record that I think that DataGrid [i]should[/i] contain a columns collection. It would be useful.

Thanks for the help - I'm the only "programmer" (I'm really a mathematical-statistical analyst) in my company so there's no one for me to take my sinple, dumb questions to in person.

-stormin

The ends can never justify the means. It is the means that determine the ends.

Re: hide data grid columns

Wjousts11-Oct-05 4:29

Wjousts

11-Oct-05 4:29

Something like this should work:

<br />
DataGridColumnStyle dgcs = MyDataGrid.TableStyles["MyTableName"].GridColumnStyles["MyColumnName"];<br />
MyDataGrid.TableStyles["MyTableName"].GridColumnStyles.Remove(dgcs);<br />

It's a little more efficient if you keep a reference to the table style and column style objects that you're using so that they don't have to be looked up each time, but the above code should work.

XML Serialization

Arshad_Ebrahim11-Oct-05 1:45

11-Oct-05 1:45

I'm a new to xml serialization and I haven't found much joy on the web.

How do i specify arbthree both nullable and a nonNegativeInteger? Or in otherwords have more then 1 attribute type?

i tried using them together like the following but I get a compile error

[System.Xml.Serialization.XmlElementAttribute(IsNullable=true)]
[System.Xml.Serialization.XmlElementAttribute(DataType="nonNegativeInteger")]
public string arbtwo;

[System.Xml.Serialization.XmlElementAttribute(IsNullable=true)]
public string arbone;

[System.Xml.Serialization.XmlElementAttribute(DataType="nonNegativeInteger")]
public string arbtwo;

public string arbthree;

XRaheemX11-Oct-05 3:37

11-Oct-05 3:37

In the code you posted above, it is correct to apply multiple attributes above the item such as your first example. If the entire example you have above is all in one class, that could be your problem. You are defining arbtwo twice.

I tried this but of code and it compiled with no errors:

<code>
[System.Xml.Serialization.XmlElementAttribute(IsNullable=true)]
public string arbone;
		
[System.Xml.Serialization.XmlElementAttribute(IsNullable=true)]
[System.Xml.Serialization.XmlElementAttribute(DataType="nonNegativeInteger")]
public string arbtwo;

[System.Xml.Serialization.XmlElementAttribute(DataType="nonNegativeInteger")]
public string arbthree;
</code>

Arshad_Ebrahim11-Oct-05 3:53

11-Oct-05 3:53

Sorry it does compile but I get a runtime error.

You need to add XmlChoiceIdentifierAttribute to the 'arbtwo' member.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: You need to add XmlChoiceIdentifierAttribute to the 'arbtwo' member.

XRaheemX11-Oct-05 3:59

11-Oct-05 3:59

Well the syntax of the attribute tags is correct, so your code is not compiling for another reason. Can you paste some more of the code here so we can figure out why it's not?

Arshad_Ebrahim11-Oct-05 4:09

11-Oct-05 4:09

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Diagnostics;
using System.Web;
using System.Web.Services;

namespace ITCService
{
///

/// Summary description for Test1.
///

public class Test1 : System.Web.Services.WebService
{
public Test1()
{
//CODEGEN: This call is required by the ASP.NET Web Services Designer
InitializeComponent();
}

#region Component Designer generated code

//Required by the Web Services Designer
private IContainer components = null;

///

/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
///

private void InitializeComponent()
{
}

///

/// Clean up any resources being used.
///

protected override void Dispose( bool disposing )
{
if(disposing && components != null)
{
components.Dispose();
}
base.Dispose(disposing);
}

#endregion

// WEB SERVICE EXAMPLE
// The HelloWorld() example service returns the string Hello World
// To build, uncomment the following lines then save and build the project
// To test this web service, press F5

[WebMethod]
public SomeDetail HelloWorld(InputDetail inputDetail)
{
return new SomeDetail();
}
}
public class SomeDetail
{
public int SomeValue;

public SomeDetail()
{
}
}
public class InputDetail
{
[System.Xml.Serialization.XmlElementAttribute(IsNullable=true)]
[System.Xml.Serialization.XmlElementAttribute(DataType="nonNegativeInteger")]
public int InputValue;

public InputDetail()
{
}
}

}

XRaheemX11-Oct-05 4:19

11-Oct-05 4:19

I copied and pasted everything you have here into a new class in my .NET environment and it compiled perfectly Confused | :confused:

Arshad_Ebrahim11-Oct-05 4:23

11-Oct-05 4:23

It compiles fine.

Its giving me a runtime error when I goto the webservice.

Server Error in '/ITCService' Application.
--------------------------------------------------------------------------------

You need to add XmlChoiceIdentifierAttribute to the 'InputValue' member.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: You need to add XmlChoiceIdentifierAttribute to the 'InputValue' member.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[InvalidOperationException: You need to add XmlChoiceIdentifierAttribute to the 'InputValue' member.]
System.Xml.Serialization.XmlReflectionImporter.CheckAmbiguousChoice(XmlAttributes a, Type accessorType, String accessorName)
System.Xml.Serialization.XmlReflectionImporter.ImportAccessorMapping(MemberMapping accessor, FieldModel model, XmlAttributes a, String ns, Type choiceIdentifierType)
System.Xml.Serialization.XmlReflectionImporter.ImportFieldMapping(StructModel parent, FieldModel model, XmlAttributes a, String ns)
System.Xml.Serialization.XmlReflectionImporter.ImportStructLikeMapping(StructModel model, String ns)

XRaheemX11-Oct-05 4:45

11-Oct-05 4:45

Ahhh that makes sense. Well, just out of curiosity, did you do exactly what the error tells you to do? It's not done in the example you pasted. Add the XmlChoiceIdentifierAttribute to the InputValue member See below:

<code>
        public class InputDetail
	{
		[System.Xml.Serialization.XmlElementAttribute(IsNullable=true)]
		[System.Xml.Serialization.XmlElementAttribute(DataType="nonNegativeInteger")]
		[System.Xml.Serialization.XmlChoiceIdentifierAttribute]
		public int InputValue;

		public InputDetail()
		{
		}
	}
</code>

Arshad_Ebrahim11-Oct-05 20:25