entrylevel26's Q&A profile

• SQL Server Adding Columns Dynamically

  Dear All, I have a requirement, in which i have to add columns dynamically depending the records of a master table in sql server 2000. Pl, do help me If you mean a query, than there is no way to do that beside dynamic SQL. if you want to use dynamic SQL, make sure you first read the article of Erland to fully understand what you are doing: http://www.sommarskog.se/dynamic_sql.html HTH, Jens SUessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Visual Studio 2008 (Pre-release) Little help plz

  Hi i have the following code taken from a tutorial. Now i wish to return a string called returnString but it won't compile because the string is being accessed from another class. So how do i return the string Basically i wish my service to access objects from the application hosting the service. Thanks. using System; using System.Collections.Generic; using System.Text; using System.ServiceModel; namespace Messenger { public class ClientService { ServiceHost serviceHost; String returnString = "String I want to return"; public ClientService() { } public void startService() { Uri baseUri = new Uri(" http://localhost:1234/hello "); serviceHost = new ServiceH ...Show All

• Software Development for Windows Vista Go Live and June CTP?

  Is there going to be a go live for the Release Candidates There will not be a go live license for WF RCs. You will be able to download the WF RTM bits as a standalone install within one week of the Office RTM release. Thanks, Joel West MSFTE - SDE in WF runtime and hosting This posting is provided "AS IS" with no warranties, and confers no rights ...Show All

• SQL Server counting records in all tables

  Hello all,    I was wondering if there is anyway to find number of records in all tables instead of count one table at a time by select count(*) from table_name. thanks   Hello Ryan and all, I am using SQL Server 2000; therefore, I won't be able to see table as sys.schemas and sys.tables. Would you advise how to do this in SQL Server 2000 thanks ...Show All

• Visual Studio Express Editions How to copy from resources?

  Hello.I wan't to create a setup project in c#.How I can make my application to store files (or archive them, if it can) It is good from resources Create a new setup and deployment installer project in Visual Studio. I am unsure if the express edition has this, but if not, then you are best to probably find one on the internet. ...Show All

• Windows Forms Column Types in the DataGridView Control

  Is there any way to tie-down input in DataGridView column according to type values which that column represent. For example type column1 is numeric, column2 is alphanumeric, column3 is date, etc. How allow entry legal values and forbid entry illegal values to cells of DataGridView Thanks in advance for any help with this question. Ross Dargan's response assumes you are talking about web "GridView" System.Web.UI.WebControls. GridView My response assumes you are talking about windows form's "DataGridView" System.Windows.Forms. DataGridView ...Show All

• .NET Development CPU usage hitting 97% by worker Process

  We have the following environemnt windows2003 Server --IIS6.0 running in IIS5.0 isolation mode Dotnet1.1 Framework We have close to 20-25 dotnet as well as Asp applications running under a single website. we are getting "Exception of type System.OutOfMemoryException was thrown" messages in our applications periodically. we notice that the CPU usage hits 97-99% during this period. i can see 2 aspnet_wp.exe in processes and killing one of them always brings down the CPU usage to 1-2% Server Configuration - 8 Processors (3.1ghz), 8 gb RAM I aslo did a basic search on this problem and found that ... webgarden - this is set to false. Will enabling this in machine.config solve my problem find the processmodel secton i ...Show All

• Visual Studio Express Editions Programming a button to directly open a .exe file!

  I am making a program that will open a file when you click a button. I don't need to access the open dialog, I would just like to click the button and the .exe file opens. I am burning a bunch of programs to the same cd so i have to be able to open the one specific program and only that program with that button. I am trying to open this file with the button: "IE7-WindowsXP-x86-enu.exe" So if I had a button and I clicked it and it directly opened that file that is exactly what i am looking for. If anyone could give me a hand that would be great!! Dim theDriveLetter as String = Application.StartupPath.SubString(0, 3) Process.Start(theDriveLetter & " fileName.exe ") and thats it! You ...Show All

• Visual FoxPro Copy and Past function under VFP9

  I found the Ctrl+C and Ctrl+V function under VFP9 is not working on the users' end. Sometimes, I found the same problem on my PC. What seems to be the problem They work. If not then add their menu definitions to your code. ie: Create a quick menu. From generated menu copy edit menu (leaving only those bars if you want) and add to your code. Just having the definition is sufficient. No need to activate a menu. ...Show All

• Visual Basic Piano computer~ please help

  Well I'm a newbie at programming and so far I could only figure out a few things. I'm creating a piano program using visual studio 2005 in Console Applications. The program lets the computer keyboard act as a piano in which the key are synchronized to a specific piano note. When the key is pressed, a piano note is played. My main problem is that the program won't let you play 2 or more notes at the same time. If you try and play 2 or more notes the program only plays one. I tried to look for some tips but alot of people say that the program can't read two commands at a time. So I really need help. Can someone tell me what to put in my program so it can play more than one note at a time. Here is my c ...Show All

• Visual Studio Team System Error in Schema Compare - CTP5

  In my database I have several CLR functions in one assembly. I use most of the functions in table to calulate something. A typical table would look like: ID bigint IDENTITY PRIMARY KEY Name varchar(50) Result dbo.CalcSomething(ID) where CalcSomething is a CLR function. When I change the assembly (e.g. add a function etc.), the columns in the table are not dropped, but the CLR functions are re-recreated. Since these functions are in use (no dropping) the script will fail ever time. Would be nice to fix this in RTM EDV Gradl - Has your issue been resolved with CTP6 If it has not been resolved, then please provide the additional information requested by BrianKu and we will see if we can diagnose the pr ...Show All

• SQL Server Joining two DataSets

  How do you join two datasets in reporting services... one from sql and another from oracle Thanks Currently, datasets cannot be joined on the report. Some options you can explore: 1. Join the datasets at the database level by using the SQL Server linked servers feature. 2. Use a subreport for one of the datasets which can be synchronized with the master with parameters. 3. Use a SQL Server 2005 CLR stored procedure to fetch and join the ADO.NET datasets. 4. Write a custom data extension. This is the most intensive option which I will suggest as a last resort. ...Show All

• Visual Basic VB.NET FORM CHILD OF VB6 MDIFORM

  I'm goin' crazy. We have to manage an MDIForm in VB6, it calls a .NET library which shows forms inside the VB6 MDIForm. what we'd like to do is including .NET forms in the VB6 MDIForms we use a sentence like this VB6 code: Dim c As New MyClassLibrary.MyClass c.GetMyForm Me when I run this code .NET throw the following exception: Unable to cast COM object of type 'System.__ComObject' to class type 'System.Windows.Forms.Form'. Instances of types that represent COM components cannot be cast to types that do not represent COM components; however they can be cast to interfaces as long as the underlying COM component supports QueryInterface calls for the IID of the interface. in which way I can solve the problem could you give ...Show All

• .NET Development XML code still work?(Simple)

  Hey, If my XML file looks like this: < thetoolbars > < Fontbar > 1 </ Fontbar > < Mainbar > 1 </ Mainbar > </ thetoolbars > Will this still work : XmlTextReader theReader = new XmlTextReader ( Application . StartupPath + "\\options.xml" ); while (theReader.Read()) { theReader.MoveToElement(); if (theReader.LocalName.Equals( "Fontbar" )) { string thevalue = theReader.ReadInnerXml(); if (thevalue == "1" ) { toolStrip2.Visible = true ; fontBarview.Checked = true ; } else { toolStrip2.Visible = false ; fontBarview.Checked = false ; } } } theReader.Close(); Becuas ...Show All

• SQL Server need direction on SSB replacing existing technology

  Hello, I have an existing suite of applications in my company where remote laptop users enter data into a local database instance. There are several different applications with several different databases (some users run application A and C, others run A and B and D, etc). All of this data needs to make its way into both their local databases, and to the front office database. In addition, some of the data goes out of the front office to other end users (supervisors get data from people under them). Currently, we get the data back and forth by creating text files full of SQL statements that are run on either the end user servers or the main server, and we zip and ftp these SQL Script files back and forth. I am looking into the benefits of ...Show All