remisp's Q&A profile

• Visual Studio Express Editions Is the Conservation Of a Computer System’s Resources a Virtue or An Evil?

  Hi There..... Is Minimal use of a Computer System’s Main and Auxiliary Memory a Virtue or an Evil Thanks Hi jmcilhinney.... I was really surprised it was checked the other day when I saw it was checked..... Well I uninstalled the Checked version and unchecked it and republished today.... the app published and executed a charm without SQL server Express checked.... I was fooled an shot out some bad inf ...Show All

• Visual Studio Team System Project Site Login error to Report Server

  I am getting the following error when I go to the project site: Reporting Services Error Marc, Under IIS Admin, if you go to the properties of your reporting site, is your authentication set to "Integrated Windows Authentication" You can verify this with by going to the Directory Security tab and clicking on "edit" under "Authentication and Access Control". Also be sure to verify all the sites under the ...Show All

• Visual C# How to display columns from a database table in a combobox?

  my table name is Students with columns ID, Name, ... Hello Create a DataSource, Set the combo box datasource property to the created datasource, then set the combo box displaymember property to "Name" and valuemember property to "ID", so in this way all the names will be populated in the Combo Box. ...Show All

• Visual C# How to find a System Tray Process

  Hi, I'm trying to retrieve a process from the System Tray programmatically. My program starts the process and then saves the Process object. Later, the program tries to locate the process and bring it to the front (in focus). For all processes that do not reside in the system tray, I can do this with no problems. When I call AppActivate on a process that is in the SystemTray, the ArgumentException is raised. Does anyone know how to ret ...Show All

• SQL Server Import/Export data with SQL Server 2005 Express

  Hello folks! I have installed SQL Server 2005 Express and SQL Server Management Studio Express. Everything looks ok and works fine, but I can't find the Data Import/Export Wizard.  Can anyone tell me how to Import/Export data Thank you!!! Hi swami, Could you pls give me more info as to how to run DTS. I have installed Sql server 2005 Ex Ed. Is it possible to install only the DTS from SQL 2000. Tnx ...Show All

• SQL Server How to reference a previous field Alias in TSQL as in Jet SQL?

  My question is simple, I'd like to do something I do in Jet ANSI-89 SQL. Mind you I'm just adding numbers here - they are not actual columns in 'SomeTable' SELECT 1 AS A, 2 AS B, A+B AS C FROM SomeTable The Jet engine evaluates and does arithmetic on the Aliased column names - handy when they contain their own functions. The resultset would show: A B C 1 2 3 However from what I can tell SQL Server 2005 is not picking this up. Is their an ...Show All

• SQL Server Generate Scripts option in SQL 2005 Management Studio

  Did anyone even bother to test the Generate Scripts option for a database I changed the following options from their default setting: "Include Descriptive Headers" = True "Include if NOT EXISTS" = True "Script for Server Version" = SQL Server 2000 "Script Indexes" = True and scripted all Stored Procedures, Tables, User-defined functions, and Views Problems: 1.  Generates IF NOT EXISTS (SELECT * FROM sys.objects ... should be ...S ...Show All

• .NET Development Where did the newsgroups go?

  Am i missing somethign I cant find the MSDN newsgroups anymore. Are the forums supposed to be a replacement for the newsgroups Hello John, The MSDN Forums are another tool for interacting with various communities, but they are not a direct replacement for newsgroups. I believe the MSDN newsgroups link is: http://msdn.microsoft.com/newsgroups Please let me know if that link does not work for you. You ca ...Show All

• SQL Server Connecting to SQL Server via a Lan Connection

  Hi, I have developed a windows form application which connects to a sql server 2k database via the following conneciton string: Private con As New SqlConnection("Data Source=(local);trusted_connection=true;Initial Catalog=Database1") This works fine for running locally but I need to give my Windows form application to other users on the lan and have them reach my database server.  So next I tried: Private con As New SqlConnection("Work ...Show All

• Visual Studio Threaded load of ReportViewer? (GUI Thread Issues?) Progressbar Marquis effect?

  Hello, I am trying to load a very simple report in my Windows Forms application. There are only five our so fields that get populated. Currently, I am doing this via ReportParameters defined at design time, and setting their values programatically at run time. The actual report is displaying just fine. What is NOT working well is the actual load time / performance of the report. It takes about three seconds in RELEASE MODE, outside of the IDE, ...Show All

• Windows Forms DataGridView changes not saving!

  Hey Guys, I am writing an app with Visual C# Express and have put a DataGridView on my form. It pulls data from an Access database and displays it fine, but when I edit, add, or delete a record from the DataGridView control the changes "appear" to have taken, however once I close the app and reopen or check the Access database none of the changes have taken affect. I didn't write any insert, update or delete statements as I thought that funtio ...Show All

• Visual Basic TcpListener Object

  I am writing an application that uses the TcpListener object from the System.Net.Sockets namespace and had no trouble in .NET 1.1, but am getting a message now complaining that my constructor has been depreciated. Here's a code snippet:         Try             m_Listener = New TcpListener(5000)           &nb ...Show All

• Visual Studio Team System Technical Requirements in CMMI

  Where do technical requirements fit in the CMMI process If a functional requirement is created, where do the technical details go I'm sure we do things backwards here, but let me give you a peek at what we do. Our data analysts create the functional requirements. The developers then take those functional requirements and fill out how they will meet the requirement in a "technical requirement" tab that's linked to the functional requirement ...Show All

• .NET Development Year function in sql query

  I'm trying to add a field in query design SQL EXPRESS as follow SELECT Year([Created_Date]) as exp1 FROM Tablex or SELECT Datepart(year,[Created_Date]) as Years FROM Tablex Table comming from MSAccess I have donne in MSAccess many time without a problem , but I get an error in SQL what wrong , please help Error source:Microsoft Jet Database Engine Error Message:Undefined fun ...Show All

• SQL Server Failed Install of SQL Server 2005 SP1 CTP

  Hello, We are attempting to install the CTP for SQL Server 2005 SP1 and receive the following error message in the log: The following exception occurred: Unable to install Windows Installer MSP file  Date: 03/24/2006 14:19:40.562  File: \depot\sqlvault\stable\setupmainl1\setup\sqlse\sqlsedll\copyengine.cpp  Line: 856 This is then followed by this failure with the Database Services: Product: Database S ...Show All