SillyMS's Q&A profile

• SQL Server Run an Access Query w Parameters from a SQL Server procedure (T_SQL)

  Hope this is the right group. I want to run a query which belongs to an Access mdb file from a stored procedure stored on SQL Server. It is possible (using T-SQL) (Note: to run an Access query without paramater: select * from openrowset('Microsoft.Jet.OLEDB.4.0', 'C:\Data\App\ShipManager\Bunker\Data\Work.mdb';'admin';'', 'select * from QStock') as S ) Thanks in advance, grig petrescu ...Show All

• Visual C# Create separate executable file

  Hi, I have created a windows application project , and I need to run it on different PCs. I need to make an executable file to it. I know that there is one in the bin directory, but when I try to use it on another PC, that has not install VS. Net, I have got an error and the program does not work at all. I need to make a separate executable file, if this is the solution, or how can I solve that Thanks in advance, Aya. To run the .Net based application on any computer. The computer must have .Net Framework installed on that. Does the other machine have .Net Framework installed If yes, then can you post what error message your are getting Best Regards, ...Show All

• Visual Studio Express Editions How do I cause a desktop icon to be placed during installation of my application?

  When my application is installed on the user's computer, I want an icon to always automatically be placed on his desktop. ClickOnce did not offer this. How can I do it (Visual Basic 2005 Express) This link describes how to create shortcut that leads to certain location (or leads nowhere) and include it in setup project so it appear on desctop. If application installed in other location shortcut will not change. Pitty but this link is totally useless. Noone needs shortcut that can not be automaticaly changed during installation. ...Show All

• Visual Basic need a sound file

  I need a wave file. It was on my old computer that I no longer have. The sound file I need is: Utopia Error.wav Anyone know where I can find this file Not really anything to do with VB.NET Maybe a bit off topic for this forum but looking at the following http://support.microsoft.com/kb/180465 It would appear to have been part of the Windows 98 installation. I would suggest looking back to you original Windows Media to locate these files. ...Show All

• Windows Forms Contextmenu control

  How do you use what is selected in a contextmenu strip from an icon in the status bar I have created 3 menu items and I need to perform a different task for each. I can view them and select them, but I cant intereact with them Davids Learning You can implement the "Click" event for each menu item, and take the appropriate action you want inside the event handler. Here is an example: Public Class Form1 Private Sub SayHelloToolStripMenuItem_Click( ByVal sender As Object , ByVal e As System.EventArgs) Handles SayHelloToolStripMenuItem.Click MsgBox( "Hello" ) End Sub End Class -Scott ...Show All

• Windows Forms Clone DB

  helloo I'm building an accounting windows application, at the begining of each year the administrator must be able to create a new year DB from the application Is this possible knowing that im using SQL Server 2000, .net framework 1.1 Thank you in advanced sort of...best place you can ask on how to programmatically backup a database, and then clear out the existing database would be here in the SQL forums, once you get the commands (programmatically) then we can implement this into C# for you http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=85&SiteID=1 ...Show All

• Windows Forms update doesn't save in database

  Hi I'm sure I missing something, but I can't see what.... I take data from form1 to form2, make my changes and click on form2's save button. It updates correctly the form1's datagridview but doesn't save the data in the database. Can anyone see why it doesn't save in the database Kind regards, simsen :-) private DataViewManager dsView; private DataSet ds; private OleDbDataAdapter da1; private OleDbDataAdapter da2; private OleDbCommandBuilder cBuilderKunder; private OleDbCommandBuilder cBuilderFaktura; string myDB = "c:\\ANSI\\Fakturasystem.mdb"; private void btnRetKunde_Click(object sender, EventArgs e) { // Find den aktuelle row der er selected nar der dobbeltklikkes. Currenc ...Show All

• Visual C# Running two services in same VSTS project

  Hello... I have created two c# windows services in the same VSTS project. They each have their own installers, and installs fine in the windows service list. I have attached a debugger to the main(), here is the code: static void Main(string[] args) { ServiceBase[] ServicesToRun; // More than one user Service may run within the same process. To add // another service to this process, change the following line to // create a second service object. For example, // // ServicesToRun = new ServiceBase[] {new Service1(), new MySecondUserService()}; // ServicesToRun = new ServiceBase[] { new NetworkWatcher(), new LocalRunner() }; Debugger.Launch(); ServiceBase.Run( ...Show All

• Visual C++ location of string tables?

  I'm building a Win32 console application where I want to use Unicode. The simplest solution seems to be putting all strings into a string table. My question is: where is this string table placed when the application is compiled & linked If I always pass legal string ID's to LoadString() where the buffer is of sufficient size, is there ever a situation where LoadString will return zero (fail) Thanks. Just additional info. The RC file is compiled seperatly to a res file. This res file is added to the final executable with the linker. You can easily check whats inside an EXE when you just open the executable as a resource file in VS! ...Show All

• Visual Basic Efficient programming of repeating tasks. Possible?

  Dear all, I have a form with picturebox (picInput1) and a number (say, 20) of radiobuttons rbLut1...rbLut20 that, when clicked, will impose 20 different LookUpTables (LUTs, or palettes) onto that picturebox. Luts are derived from other picture boxes that exist: lut0....Lut20. What I made (see below) works but it is typing-inefficient AND I don't like it because it is not elegant: '***Start current code:------------------------------------------------------- Private fyCurrentLut As String = "Lut1" Public Sub rbLut0_CheckedChanged(ByVal sender As Object, ByVal e As _ System.EventArgs) Handles rbLut0.CheckedChanged, rbLut1.CheckedChanged, _ rbLut2.CheckedChanged, ............ rbLut20.CheckedChanged 'KJ aug 2006. Det ...Show All

• Software Development for Windows Vista Project type is not supported by this installation

  I have been struggling with this the entire day. I just installed for the first time: WinFX Visual Studio 2005 Extensions for Windows Workflow Foundation Beta 2_2 Windows Workflow Foundation Runtime Components Beta 2_2(EN) for x86 WorkflowTemplates - 2006-03-07 If I try to create any WWF project based on the new templates, I receive an error stating that "the project type is not supported by this installation". I have uninstalled everything and installed the Beta 2 version (instead of the Beta 2.2) and I get the same error. I then uninstalled everything again and reinstalled the Beta 2.2 version hoping that it would have worked, but no luck. Has anybody had this problem Any help will be appreciated. P.S. ...Show All

• Windows Forms Make My.Settings Use dll.config

  I have a solution with the following projects: NewLib (class library) ComLib (class library) ComLib references NewLib. ComLib exposes COM interfaces for the objects in NewLib. A VB6 app references ComLib for access to those .NET objects. NewLib has a setting called 'MyServiceUrl'. I have set the GenerateDefaultValueInCode option to false for this setting. The VB6 application loads and uses resources from ComLib without a problem. The problem is this: When an object in the NewLib assembly queries the 'MyServiceUrl' setting, it doesn't properly read it! The NewLib assembly doesn't seem to find the NewLib.dll.config file! How can I make the NewLib assembly read settings from NewLib.dll.config There does not exist an "exe. ...Show All

• .NET Development Wants to create an application which run in background

  Hi, I have to create a application that runs when client starts his computer for autoupdates Can anybody pls help me how should i start my application in background when user starts his machine Waiting for ur reply Thanks, Nilesh Nilesh Ingale wrote: Hi, one more thing i want to run the Windows Service when user gets connected to Internet. and also check when user starts his machine if already connected to Internet then run the service otherwise whenever he gets connected to Internet You need a Service Manager like one SQL server has "SQL Agent" which sits in the System Tray. It should be able to see network connectivity. For Network Connectivity see: System.Net.NetworkInformat ...Show All

• SQL Server merge two results into one

  Hi, I want to run a query which will return two results as one row. I am building a system which returns all the projects for a user that start between two dates, usually the beginning and end of the week. If two projects start during that week I get two rows of results, but I want to actually merge these two results into one row. So that I can display the project names as project 1, project 2 Instead of project 1 project 2 I did try using GROUP BY to merge the results but this didn't work, what other ways can I do this Thanks Stephen DECLARE @project nvarchar ( 2000 ) SET @project = '' SELECT @project = @project + [projectname] + ',' FROM ( SELECT ...Show All

• Visual C++ Getting an error RC2188 (Visual Studio 2005, C++)

  Hi, For some reason I'm getting an RC2188 error from the Resource Compiler when accessing the Resource View. There is no documentation for this error. Situation is, I have an RC2 file with my version info in, which is not to be edited by Visual Studio. When the message comes up, it has the path to the RC2 file with a (6) after it. Presumably this is the line number which is #error this file is not editable by Microsoft Visual C++ Anyone have any idea why this is now causing an error (has been working fine in this configuration for months) Thanks in advance Ian. Found those myself as well. Thing is tho the project is a pure bred VC8 one. I'm not using the libraries that's being ment ...Show All