Re: Excel 2003 interop - C# Discussion Boards

2-Jun-04 13:39

Magic Library provides that style. Look at the tab control samples and read the documentation (if he finally provided it like I asked so many times with prior versions).

Microsoft MVP, Visual C#
My Articles

Excel 2003 interop

Dimitris Iliopoulos2-Jun-04 12:16

Dimitris Iliopoulos

2-Jun-04 12:16

I am trying to write some data to excel 2003 from C#.
I installed windows xp on a machine,visual studio.net and office 2003 from scratch to be sure everything is ok. I also install of course .NET programmability support for the office

I write in C#:

Excel.Application app = new Excel.Application();
app.visible=true;
app.Workbooks.Open("c:/data.xls", System.Reflection.Missing.Value, System.Reflection.Missing.Value, System.Reflection.Missing.Value, System.Reflection.Missing.Value, System.Reflection.Missing.Value, System.Reflection.Missing.Value, System.Reflection.Missing.Value, System.Reflection.Missing.Value, System.Reflection.Missing.Value, System.Reflection.Missing.Value, System.Reflection.Missing.Value, System.Reflection.Missing.Value, System.Reflection.Missing.Value, System.Reflection.Missing.Value)

when i run it the first two lines work good and when it goes to the Open function a COMException come up telling me "old format or invalid type library", i also tried _Open function but the same thing happened. If i use an event in the Application object everything works fine,it crashes only when i go to the Workbooks property. PLEASE HELP

From Greece:
Dimitris Iliopoulos
dimilio@yahoo.com

Heath Stewart2-Jun-04 13:26

2-Jun-04 13:26

Did you add an assembly reference to the Office interop assemblies, or use the COM tab to add them? You should do the former. Unfortunately, they're not easy to get at. You must use the command prompt to copy them out of the respective directories in %WINDIR%\assembly\gac (you can't browse to it using Windows Explorer). If you downloaded the PIAs (Primary Interop Assemblies) from MSDN, then you have version 10 (Office XP). If you add a COM reference, then the interop assemblies in the GAC are not used during runtime, but the interop assemblies you generated.

This is a pain, I know, but necessary. Microsoft only installs the Office 2003 assemblies into the GAC and doesn't make them easily accessible for development unless you use the Office project templates in VS.NET 2003.

Microsoft MVP, Visual C#
My Articles

Dimitris Iliopoulos2-Jun-04 22:07

Dimitris Iliopoulos

2-Jun-04 22:07

Could you explain what exactly i have to do, i have to copy the assemblies in my runtime directory form %WINDIR%\assembly\gac and then add a reference to them thru the .NET tab and not the COM tab?

I really appreciate your help

From Greece:
Dimitris Iliopoulos
dimilio@yahoo.com

Heath Stewart3-Jun-04 3:45

3-Jun-04 3:45

You'll need to copy those assemblies somewhere else to use them explicitly without the designer. Start a command prompt (cmd.exe in Windows NT-based OSes) and type:

cd %windir%\assembly\gac
dir

You'll see a bunch of directories that match assembly names. You'll need to cd to each of those and then the version (should start with "11.") and copy those assemblies elsewhere, like C:\Program Files\Microsoft.NET\Office11 (recommended, where the Office10 assemblies get their own folder in that directory, which is the parent directory of the default .NET 1.1 SDK).

The important thing is that you use the primary interop assemblies whenever possible.

The way the interop assemblies are registered, however, VS.NET should've used the PIAs already. See, PIAs are typically generated by the company that produced the associated typelib and they are registered so that the typelib registry keys contain and entry that specify the PIAs associated with that typelib, so instead of creating a new typelib the old one is used.

Before you do anything, I would look at the path of the Office assemblies you've already referenced and see if the path is C:\Windows\assembly\gac\....

Microsoft MVP, Visual C#
My Articles

DataSet not Updating Database

Dimitris Iliopoulos3-Jun-04 10:40

Dimitris Iliopoulos

3-Jun-04 10:40

I ,finally after lot of search, found what is the problem. It's a bug in office XP and office 2003. When you have installed the english version of office and you regional settings are not the same then you cannot call some functions, especially in Excel, and you have to use InvokeVerb so you tell with what exactly Culture Info you want to call the method. I lost really lot of time searching for this. By the way in office 2003 the PIA work good, you don't have to do the copy you have told, in Office XP there is this problem.

Thanks a lot

From Greece:
Dimitris Iliopoulos
dimilio@yahoo.com

Sound Mixer Control

kratchkov2-Jun-04 10:39

kratchkov

2-Jun-04 10:39

How is it possible to control the Master, the Wave and the Line-In mixer controls directly?

Help!

----------------------
I think war is a dangerous place.
George W. Bush - Washington DC, May 7th 2003

Re: Sound Mixer Control

Wackatronic2-Jun-04 16:42

Wackatronic

2-Jun-04 16:42

Try looking at using DirectX as a starter. You can do some great things with it.

Yes, I program in VB6, but only because I use it to fill my addiction to having a dry place to sleep and food to eat!

Orville2-Jun-04 10:05

Orville

2-Jun-04 10:05

I have a dataset that is populated from an access database and displayed in a datagrid just fine. Then I added a button to the form for updating the database.
Here is the code for the button.

private void bntStUp_Click(object sender, System.EventArgs e)
{
int iRetVal = 0;
try
{
oDS.AcceptChanges();
iRetVal = myAdapter.Update(oDS, "tblSteps");
MessageBox.Show("The update was successful. Rows Updated: " + iRetVal.ToString());
}
catch (Exception ex)
{
// Display information about update errors.
MessageBox.Show("Update Failed: " + ex.Message);
}
}

It works fine the dataset and datagrid are updated, but the database is not updated. Is there something that I am missing?

Huh?

Heath Stewart2-Jun-04 10:22

2-Jun-04 10:22

Because you're calling AcceptChanges. This removes all the change information and the DataAdapter will find none, thus it will not update the database. Just call DataAdapter.Update, which will accept changes when the database has been updated. Read the documentation on the AcceptChanges method (defined on both the DataSet and DataTable classes) in the .NET Framework SDK for more information.

Microsoft MVP, Visual C#
My Articles

Orville2-Jun-04 10:36

Orville

2-Jun-04 10:36

I take the AcceptChanges line of code and I get this error.

"Update requires a valid UpdateCommand when passed DataRow collection with modified rows."

Now what?

Huh?

Heath Stewart2-Jun-04 10:44

2-Jun-04 10:44

It should be obvious: you need to assign a command (like a SqlCommand, OleDbCommand, or whatever is appropriate) to the DataAdapter.UpdateCommand property, using whichever DataAdapter is appropriate. How do you expect the DataAdapter to update the database if it doesn't know how to update the database?

If you use a simple SELECT statement, then you can also use a command builder like the SqlCommandBuilder to build the INSERT, UPDATE, and DELETE statements for a DataAdapter. See the .NET Framework SDK documentation for more details.

Microsoft MVP, Visual C#
My Articles

Want to mouse click a toolbar button?

Orville2-Jun-04 10:59

Orville

2-Jun-04 10:59

Thanks I will look at that.

Huh?

Anonymous2-Jun-04 9:32

Re: Want to mouse click a toolbar button?

2-Jun-04 9:32

How can I programmatically push a toolbar button?

foreach (ToolBarButton refBtn in toolBar1.Buttons)
{

if refBtn meets some condition then click it. Just like a mouse click.
refBtn = left moust click;

}

thanks

Heath Stewart2-Jun-04 10:18

Re: Want to mouse click a toolbar button?

2-Jun-04 10:18

If the ToolBar.ButtonClick event handler is accessible (i.e., in the same class or with an access modifier that allows it to be access from outside your class), then just call it like so:

public class MyForm : Form
{
  private ToolBar tb;
  public MyForm()
  {
    tb = new ToolBar();
    Controls.Add(tb);
    tb.ButtonClick += new ToolBarButtonClickEventHandler(tb_ButtonClick);
    // Add buttons
  }
  private void tb_ButtonClick(object sender, ToolBarButtonClickEventArgs e)
  {
    // Do something depending on the button.
  }
  public void ClickButton(ToolBarButton b)
  {
    tb_ButtonClick(tb, new ToolBarButtonClickEventArgs(b));
  }
}

Otherwise, you'll have to P/Invoke the SendMessage API and send the TB_PRESSBUTTON message like so:

[DllImport("user32.dll")]
private static extern IntPtr SendMessage(
  IntPtr hWnd,
  uint msg,
  IntPtr buttonID,
  IntPtr press);
public void ClickButton(ToolBar tb, int position)
{
  if (tb != null)
  {
    SendMessage(tb.Handle, 0x0403, new IntPtr(position), new IntPtr(1));
    SendMessage(tb.Handle, 0x0403, new IntPtr(position), new IntPtr(0));
  }
}

See the Platform SDK documentation for the TB_PRESSBUTTON message for more information.

Microsoft MVP, Visual C#
My Articles

Anonymous3-Jun-04 3:34

Disable auto-incrementing version

3-Jun-04 3:34

That was a fantastic answer!

thank you

Anonymous2-Jun-04 9:31

Re: Disable auto-incrementing version

2-Jun-04 9:31

I was wondering if anybody knows how to disable the version auto increment feature in Visual C# .NET???

Heath Stewart2-Jun-04 9:55

Re: Disable auto-incrementing version

2-Jun-04 9:55

Get rid of the asterisk in the AssemblyVersionAttribute typically found in the AssemblyInfo.cs file and use your own 4-digit versioning scheme. This is best for larger solutions anyway. We have our own scheme we used that I designed for the ~60-project solution I maintain. Especially with late-binding, automatic version is a real pain.

Microsoft MVP, Visual C#
My Articles

Anonymous2-Jun-04 11:27

Re: Disable auto-incrementing version

2-Jun-04 11:27

I tried that and set the version to 1.0.1.1 and when I built it it still incremented. Any ideas?

Heath Stewart wrote:
We have our own scheme we used that I designed for the ~60-project solution I maintain.

Would it be possible for you to share this system?

Heath Stewart2-Jun-04 11:49