NaturalInterface's Q&A profile

• SQL Server How to execute SSIS package inside of Visual Studio?

  How to execute SSIS package inside of Visual Studio I have opened the file, but  do not see any way to execute it. Please advise. Thanks There are different circumstances which may cause this. When a package opens up it validates that it can "see" all of the external connections. It may be taking time to do this for one/some/all of your connection managers. Perhaps there are network issues, something like that. It could be all manner of things. -Jamie   ...Show All

• SQL Server Backup databases programatically.

  Hello 1. Sql Express supports SMO 2. If so How can I make a backup of a database programatically Thanks You do know that you can overload the Server instantiation to direct it to the server you want to connect to, don't you Example: Dim srv As Server srv = New Server("MyLapTop\Express") In VB.Net you can also set the property in the ServerConnection object: Dim srv As Server Dim srvConn As ServerConnection srv = New Server srvConn = srv.ConnectionContext srvConn.LoginSecure = True srvConn.ServerInstance = "MyLapTop\Express" Either one should work for you. ...Show All

• SQL Server sql statement: listing all values

  Hi, i have two tables. Users: - userid, username Location: - userid, postalAddress, timestamp i want to create a view that lists all users (id and name) along with their latest Location address. i use the following sql statement which: select Users . name , Users .userid, Location.postalAddress from Users inner join Location on Location . userid = Users . userid where Location . timestamp IN ( Select MAX ( Location . timestamp ) FROM Location group by Location . userid ) The problem with this statement is that if for some users there is no location data then such users are not li ...Show All

• SQL Server SSIS - Add a new SQL Server Mobile Destination

  Hi, I try to add a new SQLMOBILE Connection. In the "ADD SSIS Connection  Manager" I select the type of connection to add to the package. (SQLMOBILE) Then in the "SQL Server Mobile Connection Manager Editor" I browse and I try to find my mobile device, but i don't find it. Obviously, I Find my shared folder "Qtek2020i My Documents", but i can't to connect to the device by "SQL Server Mobile Connection Manager Editor". The error message is: "The SQL Server Mobile connection cannot be acquired. Could not create a managed connection manager" . I don't understand because it does not work, infact by SQL Explorer I can to connect to my device ...Show All

• Visual Studio Express Editions Stop Row Deleting

  I have a DataGridView with some rows displayed and would like to check if there is any related data before deleting the row. I have a foreign key constraint but would like to popup a nice message when the user tries to delete the row rather than wait until they click on save and have the ugly, default error message. My first thought were to put some code in the RowDeleting routine. I have tried putting in a popup message along with e.row.canceledit and e.row.rejectchanges but the row still gets 'deleted' (until I click on save and get the FK error) Any suggestions hi, you can depend on t ...Show All

• .NET Development How can I communicate with an Java (JDK 1.5.0) Application over the Network with with Serialized Objects?

  Here is the problem I am looking to solve.  I have done a fair bit of searching on it but there is little to nothing on the web about Cross Language communication between Sun Java and C#. I want to send serialized objects between J2SE (Sun Java JDK 1.5.0) applications and a C# server program.  The server program also needs to be able to send objects back to the J2SE client program.  Both need to be able to read the objects and interact with them once deserialized.  Due to cross OS compatibilitys, a pure C# solution is not an option.  Also, what if any other considerations would apply if the rolls were reversed ( ...Show All

• Visual Studio Express Editions Adding a second form

  In NET 2003, I read this instruction in a book: "Visual Basic .NET requires that you specifically declare a variable of the form's type before you use a second form." Assuming two forms frmMain and frmHelp, I would do this in frmMain: Dim frmHelp As New frmHelp frmHelp.ShowDialog() But in NET 2005 (Express) it seems to work without the Dim: frmHelp.ShowDialog() Has the requirement changed Hi Visual Basic 2005 now supports shared forms which means that you can reference a form without having to first instantiate a new instance of it. You can also access your forms v ...Show All

• Visual Basic Click-Once is not so simple...

  ok, here's the problem: i'm using VB.NET 2005 beta 2 all working nicely. i've made an app, debugged it and it runs all nice from the normal exe. but when i went to publish it, it seemed to work all fine until the installation page opened. i try to launch it but it says the "application is improperly formatted". clearly it isn't because i have run the bin exe many times. now, not only does the publishing not work, but when i go back to run the normal bin exe i get another error, once which has never appreared before! it compiles fine, BUT i receive an error saying that the project can't be run: "application configuration is incorrect". s ...Show All

• Smart Device Development print function

  does .net CF 2.0 support print function....How do i connect to my printer Can i perform print job it when i cradle my PDA or using the wireless or bluetooth connection to connect to the printer. Assume that it is portable printer. another alternative http://www.codeproject.com/netcf/CFPrinterClass.asp df=100 ...Show All

• Software Development for Windows Vista knowing wich activity idled the workflow.

  Hello I have a workflow that has several HandleExternalEvent actvities. I would like to know wich activity was the one that set the workflow on an idle state. Thanks in advance, Matias One way would be to use Tracking service to find the last HandleExternalEvent activity that executed before the workflow idled. For an example of how to use tracking please see the WF sample: SimpleTrackingSample Thanks, Vignesh ...Show All

• Visual C# start process as system user.. c#

  Hi i was wondering how other make possible to start a process as a system user.. you know that in task manager when it shows what user started that process it also showes by what user.. i see many apps doing that... anybody knowes how to do that You can use the CreateProcessWithLoginW method to start an process with an other account. A great article and working code can be found here, RunAs class . ...Show All

• Visual Studio New project type (like an HTML editor)?

  Hello! I read a lot about extensibility both from this forum and VS SDK but I still can't figure this out: how can I create a whole new project type what I need it's something similar with an HTML editor where I can use the Solution Explorer (to show the folders and files in a site), the Properties tab (for reading and setting various properties of the input controls), some commands in menus (let's say Copy site via FTP), perhaps some items in toolbox (add <image> in page) and so on. Very close to what I need seems to be BscPrj from samples but it's really huge and is written in C++. Something lighter seems to be MyProject (also ...Show All

• SQL Server to display image from local system

  Hi, I am using a report server to run the reports. I have folder containing images in the local system where i run the http://RSServer/ReportServer to run the reports. i use a parameter to assign the path for the image to be displayed. i pass the value like this - file:c:/Labels/RGlogo.gif. but the reports looks for the image in the ReportServer Machine the above mentioned path instead of looking in the Local system..... how can i display the images located in the local system What are you using for the Source of the image It should be External -- in this context, External means not in the RDL or the catalog. Th ...Show All

• SQL Server ASP.NET and OLAP offline cube

  Hi, I would like to know the provider for OLAP offline cube, I mean to say that how I would able to connect to offline cube from asp.net, Please help me on this. Jag Use OLEDB. There are many examples on the Internet so search for: asp.net oledb. Here is an overview of the architecture: http://msdn2.microsoft.com/en-us/library/ms174518(SQL.90).aspx You will also need a local cube engine (msmdlocal.dll) on the client machine. It is described in detail in the article I mentioned above. ...Show All

• Windows Forms Dispose method for my class library

  I've made a class library and I want to add a dispose method to it. I've look into the MSDN-help, but I don't understand all this long code including protected overridable methods....... Can't this be done with som simple code. Public sub Dispose() '''what goes in here End sub I've tried whith GC.Collect() and GC.finalize(), but it dosn't seem to work. Any suggestions There is a clear page on MSDN that covers a lot. The Garbage Collector and Finalizing isn't a topic you just learn with what goes in here . Read that page and look at this small example: public class MyClass : IDis ...Show All