Rick Frankel's Q&A profile

• .NET Development Newbie - How can I copy data from one server to another?

  I need to copy data between my company and another without user intervention. I've spent the past couple days learning about Web Services using VB .NET. Of the examples that I've found I only have learned about getting the data to display in a browser. This is my first exposure to SOAP, XML and the rest of Web Services. Any guidance is greatly appreciated. Thank you, Martin mdsawyer58@yahoo.com ...Show All

• Windows Forms always on top

  What code do I use in VB5 to make an application always on top Thank you, Fred Jones Why the double post This is a forum dedicated to Windows Forms, which is the set of tools for buildings graphical clients using the .NET Framewo ...Show All

• SQL Server Overlapping Header for Table

  Two table are set up in report. First table carries dynamic header and the second table carries data. When my report is generated and go to the second page my first table which is carring header does not appear, I only see the data from the second table. I think my second table is overlapping my first table. I have set up the properties on the first and the second table to repeat headers = true. Can you please help Thanks. ...Show All

• SQL Server Could anyone attach the AdventureWorksDW to their SQL Server database engine?

  Hi, all here, I got a problem when trying to attach the AdventureWorksDW sample database to the SQL Server database engine. Error occured as: could not find row in sysindexes for database ID 21, object ID 1, index ID 1, Run DBCC CHECKTABLE on sysindexes . The sample database was downloaded from http://www.microsoft.com/downloads/details.aspx FamilyID=e719ecf7-9f46-4312-af89-6ad8702e4e6e&DisplayLang=en . So could anyone help me to so ...Show All

• SQL Server SQL SERVER 2005 INSTED OF Trigger

  Hi. I set an INSTED OF INSERT trigger on a table, that deny the addition of rows in some conditions. My question is: When I run the insert command, I get the (X row(s) affected) message, even if X isn't the real number of added rows. I tried to set the @@ROWCOUNT function, but it turns out this isn't the way. Is there any way to change the affected rows count of a trigger / sp Thanks, Yaakov I think the @@rowc ...Show All

• Microsoft ISV Community Center Forums Need recommendation on Office/VBA/.NET/C# solution (cross-posting from the VSTO Forum)

  ****** The reason that I am cross-posting this from the VSTO froum is to reach the widest expert base. Thanks. ****** We want to move logic currently in Word XP VBA to C# component(s). What the VBA code basically does is calling Web Services that are implemented in Java, and display the returned data in Word documents. Our requirements are: improved performance easiness to install the components on end-user's PC's ability to be shared the ...Show All

• Visual Basic when I m developping, clicking a control once in a form goes directly to the code window

  Hi dear, While I m developping (not runing the application), When  I click my existing control which is already part of my existing form in order to move it to another location within my form, I get switched to the code window mode instead of staying in designer mode, and tht prevents my from moving my control. So, please if u can show me how to stay in design mode when clicking the control once. Thanks. Check your Fo ...Show All

• Visual C# Context menu question

  Hello   Hope its the right place for this question.   I have a win app that contains a treeview and a main window. When ever I click a node in the tree it displays the content of the node in the main window. I would like to add a right click menu to the tree. The problem is that the menu may change from one node to another . What is the best way to handle this subject Is there a pattern I can use On every right cl ...Show All

• Windows Forms DefaultCellStyle.Format for an unbound row doesn't work.

  I add a DataGridView to a form and use the IDE to set the DefaultCellStyle.Format for one of the columns to "C2".  When I run the form, I can enter any value of any type and nothing gets formatted or validated. I tried setting the value in the form's constructor as well, but the results are the same.  Why doesn't this work     Assuming this is unbound... Usually a cell format pr ...Show All

• SQL Server R

  Let's imagine I have a list of countries and the number of people for each of them. I would like to create a matrix representing the bigger countries which contain 50% of the mondial population. The "top N" and "top %" function won't do the trick. If I had to create this matrix manually I would just order the country list by the number of people, and add each line in the matrix until the total amount of people represent 50% of the mondial pop ...Show All

• Visual Studio Tools for Office User Define Function, Action Pane and Worksheet

  Hi, I found the article by Eric about User Define Function is very useful! Moreover, I face a question now is that this class is completely separated from my VSTO2005 project, I mean, this Addin class is more or less like providing few "Helper Functions" only, and I'd like to know how I can create UDFs and work with my custom Business object For example, I've created a DataSet and binded to a DGV in ActionPane, and then now, I'd like to cr ...Show All

• Visual Studio 2008 (Pre-release) Web site dedicated to LINQ, XLINQ and DLINQ: LinqInAction.NET

  I've recently published some posts about LINQ on my weblog, but since I'll be doing that more and more and because I'm currently writing a book on LINQ, I've decided to open a site dedicated to LINQ, DLINQ and XLINQ ! Hopefully, the book and linqinaction.net will give you everything you need to make the best out of LINQ and co. Fabrice I must admit that the RSS feed is a bit hidden. Blame it on Community Server... Here it is: http://linqin ...Show All

• Windows Forms A real 'Newbie' question about data binding...

  I've been working with VB.NET for about a month now. Mainly been using a third party control by Janus (GridEx and Schedule). Have become pretty knowledgable on that. But totally skipped the basics.  I simply want to create a databound form connectin ...Show All

• SQL Server Dynamically change the servername

  Hi all, I've created 1 solution and added all my packages in different projects (like DIMENSIONS, SOURCES_SAP, ...). For each project I have a Data Source that connects to the server. The problem is that when I want to deploy a package to the server that I always need to change the Data Source before deployment. Before SQL Server 2005 we used a connection file (which was located as well on the server as on the development pc's in the sa ...Show All

• Visual C++ Code running help

  I am using visual c++ 6 enterprise edition. When I try to execute small uncomplicated codes, VC stops the program suddenly and give me the following message: Loaded 'ntdll.dll', no matching symbolic information found. Loaded 'C:\WINDOWS\system32\kernel32.dll', no matching symbolic information found. The thread 0xA14 has exited with code 0 (0x0). The program 'C:\Documents and Settings\PREMS\Desktop\C++\Debug\try.exe' has exited with code 0 (0x ...Show All