rp0513's Q&A profile

• Visual Studio Tools for Office VSTO and OLE Automation

  Hi, I have a VSTO-enabled Excel spreadsheet which works just fine when I open it standalone. I use the VSTO Startup event to add some document actions. Now I am trying to open the spreadsheet programatically using the following code: Excel.Workbook wkb = _app.Workbooks.Open(strFileName, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type ...Show All

• SQL Server Cross Row Referential Integrity

  In SS05 XML typed columns, is it possible to have cross row constraints and referential integrity Say I have a column with two schemas: Author and Book. Each has an ID. Each row in the table has only one author or book. Can I enforce that all Author ID are unique across all rows and that there is an author for every book Is it possible now If yes, how If no, is there a plan to add this feature in the future Is there any work around now ...Show All

• .NET Development Enable/Disable network card

  Hi. Is there any possibility to control the network card ( enable/disable) using c# in .NET Framework 1.1 Thanks.Mircea Can you point me to the right direction so I can solve this problem Thanks. Mircea ...Show All

• .NET Development Text in XSLTransform

  I am transforming one xml file to another using XSLT file. I create XSLTranform and load the stylesheet before calling the transform function. It seems to work fine but there are a few problems with text. When the XML file that I am trying to transform includes special text such as "￡" sign the transformation will fail. I assume that I need to set some parameter to support w_char or unicode somewa, but I can't seem to fine the information needed ...Show All

• Visual Studio Express Editions Cannot register a test dll

  Build following code into a dll try to regsvr32 the dll and get an error of dllregisterserver entry point not found. Dll is to be added to program via a hook in registry. What am I doing wrong Public Class TEST_MODULE Public Function Process(ByVal Session As Object) As Boolean 'Dim posSession As QSRules.SessionClass Dim posSession As Object posSession = Session MsgBox("Hello World") Process = True End Func ...Show All

• Visual Basic vb 05

  I would like to changes my batch files into a vb.exe or a msi file.  I can't find anything on that subject at all in visual studio 05 for vb.  Can somebody point me in the right direction, I'm new at this right now.The batch is set to backup system files and then zip them up using winzip. I'm not sure that it makes a lot of difference Paul. We can be sure of one thing..... Batch file work arcross entire programs to do molar ta ...Show All

• SQL Server Single record per page

  Hi All, I am new to RS2000 but have made a report that i need to have 1 record shown per page. the paper i am going to print to is 254mm x 178mm. I cant seem to figure this one out so any help or advise is most welcome You can a grouping to your data region, use RowNumber() function to control how many records belong to each group, and add a pagebreak on the group. This page contains a sample of how to do this ...Show All

• .NET Development Microsoft Access Parameters

  Hi... I’m try to get a result from a query with one parameter in Access: SELECT Cod_Cte, ApPat_Cte, ApMat_Cte, Nom_Cte, Tel_Cte, Mail_Cte, FMod_Cte, USMod_Cte FROM DSICatCtes WHERE Cod_Cte = @Codigo But the " TableAdapter Query Configuration Wizard " give me the next messange: " Error in WHERE clause near '@' Unable to parse the query text " This query statment works currectly in SQL Server 2005 but not in Mic ...Show All

• SQL Server Replication vs. DTS

  I am unsure whether to use a DTS package or Replication for the following: We have four SQL Server databases on four separate servers with the same data schema, one for the north east, south west, mid atlantic, and mid west. We also have one "global" database on a separate server. First, and only this one time, we need to copy data from the four regional databases to the global database. Then, at least once a day we will need to cop ...Show All

• Visual Studio Tools for Office How is that called ? And how can I access it ?

  When you are working in any wordeditor you always have this blinking line. I don't even know the german word for this thning. It's not a cursor, but it also tells you where you can write your next word. I hope you knwo what I mean, it's realy just the | you see when you write something. But how is that called And could I use it somehow with the word object model I already work with selections, range and bookmarks, but this blinking line .. ...Show All

• Windows Forms Selective Binding to DataGridView

  Hi!, I have a DataSet containing 8 columns, they are all comming from a database, when i bind it to the DataGridView all columns are displayed by default, I want to restrict that to bind only let's say 5 columns and not 8, without changing the Dataset. Thanks. I find out how todo it, the DataGridView has a Visible property which is a Boolean, by setting it to False it hides the column. ...Show All

• SQL Server Users Cannot Connect to SQL Server 2000 SP4 After Applying Hotfix (build 8.00.2148)

  Users are reporting that they cannot connect to SQL Server using ODBC and Windows Authentication after I applied a SQL Server 2000 SP4 hotfix. The client-side error is: Connection failed: SQLState: '01000' SQL Server Error: 10061 [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen(Connect()). Connection failed: SQLState: '08001' SQL Server Error: 17 [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or ...Show All

• Software Development for Windows Vista How to display a Workflow in a Avalon Application?

  I try to embed the Workflow Designer to a avalon application. < Mapping   XmlNamespace="wfi"   ClrNamespace="System.Windows.Forms.Integration"   Assembly="WindowsFormsIntegration" > < Mapping   XmlNamespace="wf"   ClrNamespace="System.Windows.Forms"   Assembly="System.Windows.Forms" > <Window x:Class="AvalonWorkflow2.Window1"     xmlns=" http://schemas.microsoft.com/winfx/avalon/2005 ...Show All

• Windows Forms Duplicate content files in application cache

  Hi, Why does ClickOnce keep an extra copy of every content file in a second folder in the application cache The folder I am talking about is the one that always seems to have "exe_" and "_none_" in its name. It seems like a waste of space. Any ideas Thanks, Per ...Show All

• .NET Development Computed Columns in TableAdapters

  Hello, I'm very frustrated with the TableAdapter created by the dataset designer in Visual Studio 2005. Here's my problem: My select statement is just a select * from X. Some of the columns are computed columns, and should not be included in the update or insert commands. However, they are. I can't seem to get it to not include these columns in the update and insert commands without removing them altogther. This problem did not exist in 20 ...Show All