Jason Sandlin's Q&A profile

• Visual C# Writing value to Immediate window affects the actaul program?????

  Hi, Writing some values to the output window affects the actual data. What happened is I've one dataset component and I set it's FillOnRequest=false. (if it's false, then i need to call dataset.Fill() explictly) But when i called that method it doesn't fill with data. But if I set break point on that line of code and I write 'dataset.Table[0].Rows.Count' in the Immediate window. After that data are filled in the dataset. So I was wondering the code that we write in the Immediate window acutally affect the application Any help is appreciated.. Thanks Julia168 Yes it does a ...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 Services Database Services (RTM 1399 ENU) - Failure Details: Unable to install Windows Installer MSP file I also found the following entry in the SQL9_Hotfix_KB913090_sqlrun_sqlmsp.log file: Sq ...Show All

• Visual Studio Team System Customization : add button to create workitems

  Hi, I've read the SDK documents to extent and customize workitems. However, I asked myself if it's possible to add new control on work items forms. For example : On a test workitem, I would like to create a button "raise defect". It would create a "defect" workitem and get the existing properties of his associated test. (ex : phase, test description ...) Any idea Thanks, arno   Arno, in V1 it is not possible to add custom controls to work item form and handle those events. One possibility is to create an addin that can be invoked from menu item when the work item form is dis ...Show All

• SQL Server OLAP cube processing on SQL2000 hang Big issue

  Hello, I have a SQL2000 analysis server database that was running fine for 3 years. Now, It will not process. The processing starts, then it hangs on a white screen and the cubes will never get processed. I tried to restore a 1 day older backup of the olap db that was processed and working, this backup will not process either. I tried to remove the database folder's from the Analysis services application folder and re-create all aggregations, it still hang with a white screen when I try to process. This database has a repository migrated over to SQL Server. Other databases still get processed fine. Any help would be appr ...Show All

• SQL Server How can I run and exports multiple Reports at once from Visual Studio 2005 Beta?

  Thank you in Advance, I am using SQL Server Reporting Services with Visual Studio 2005 Beta As we dont have the Email(smtp) services installed yet, I would like to run multiple reports from my computer at the same time then export results to an Excell file in My documents location: I have a project with 65 reports with their respective parameteres. If I was going to run each one individually by opening then previewing then exporting to excell it would take me a long time. Is there a Macro that I can use What is the most appropriate way to get it done Please advice. I, too, am looking for an answer to a ...Show All

• .NET Development oleDbCommand Fill error

  Hi, I have a dataset that is filled from a OleDBCommand that reads an excel file. This dataset is a typed dataset with a specific definition, meaning that it has some fields of type Double and others type string. For some strange reason when I tried to the Fill from the OleDbCommand I got an error that said: "Input string was not in a correct format. at System.Data.DataColumn.set_Item(Int32 record, Object value) Couldn't store < > in Colname, Expected type is Double." The Excel file has around 1500 records but in that column (Colname) in the first data row doesn't have any value but if I put a number it works, It ...Show All

• Smart Device Development Reservation System

  Hi. I want to make a client-server application used for reservations. The client is a pocket pc 2003 CF2 and the server app is a basic C# application running on a Windows XP Sp2. I am using VS 2005 and C#. So the basic idea is that the Pocket PC is connected by WIFI to the windows machine running the C# app. With the PP you should be able to make a reservation which will be shown in the C# app and the pp should be able to show reservations made by the C# app. 1) Is the smartes thing here to use web services or .NET remoting 2) When using web services, how can the C# app update the reservations made by the client PP Synchroniz ...Show All

• Visual Studio refresh solution explorer

  I have created an add-in that, among other things, adds a folder and file to the project currently in the solution explorer. The problem is that this new folder and file do not show up in the solution explorer unless the user presses the refresh icon for the solution (project). How can I refresh the file list in the solution explorer programatically in the add-in I have tried everything I can think of and searched everywhere. This would sure help. Thanks, Nick Hello Nick Is it a VS Language project (VB, C# or J#) that you are adding project items to, or is it a custom project type If you use one of . ...Show All

• SQL Server Error while importing Text file using Import Export Wizard

  Hi all i have text file where i can import it to excel to access or sql2000 without problem but when i import it using (sql2005 pro) i get this error message during the import O peration stopped... - Initializing Data Flow Task (Success) - Initializing Connections (Success) - Setting SQL Command (Success) - Setting Source Connection (Success) - Setting Destination Connection (Success) - Validating (Success) - Prepare for Execute (Success) - Pre-execute (Success) Messages Information 0x402090dc: Data Flow Task: The processing of file "C:\Documents and Settings\Wail\Desktop\All_Alarm5.txt" has started. (SQL S ...Show All

• Windows Forms Loading numeric data from in-project array into DataGridView

  I am trying to display the contents of a local 11 by 11 array of double precision numbers in a local 11 by 11 DataGridView in VB 2005. I was able to read data from cells within a local array and write it into cells in the MSFlexGrid in VB 6.  The closest similar display in VB 2005 seemes to be the DataGridView.  I have not found, in books or in help, any way to do this same task in VB 2005.   I find that there are three components called "BindingSource", "BindingNavigator" and TableAdapter" in VB 2005.  Up to now I have never been able work with them to get them to use a local array as the  source of d ...Show All

• Visual C++ Create an dll from existing c++ project

  Hello... I have a c++ project and want to use this in a c# program. So, I thought I could make a dll from this c++ code. But I didn't find the right solution at this moment. Maybe you can help me The c++ program consists of about 15 files (.cpp and .h). I think I have to remove the main method, but then ... In my c# programm, I want to call some functions of the c++ code... Regards, Jacquipre. Well, if the c++ code is completely native then there are two ways of doing this. But the very first thing you need to do is to create a native DLL and export all the functions you wish to export. Und ...Show All

• Smart Device Development Intercepting Key Down/Up messages in .NET

  Is this possible   I want to intercept certain keys as they are pressed and perform events on them. Thanks, Jeff. Here's a FAQ listing some additional details on what is/not possible with v1. http://msdn.microsoft.com/smartclient/understanding/netcf/FAQ/default.aspx#7.27 ...Show All

• SQL Server Beginner Q: Pocket PC access to SQL Server 2005

  Hi, I am a total beginner to Pocket PC, and a 2-month beginner to SQL Server 2005 and Visual Studio 2005. I made a database Pillbox.mdf, and wrote a Windows Forms program to access it. It's really easy. I just added a Data Source, chose tables and Stored Procedures, and dragged them onto my forms. It automatically created adapter classes and a DataGrid for me. Next, I wanted to do the same thing for Pocket PC. I did the same drag and drop thing, and was happy to see the empty DataGrid in the emulator (design-time) form. From here on, trouble. When I ran it, it said it could not connect. So some questions: 1) Does my connection ...Show All

• Visual Studio Express Editions How do you add a variable as DefaultValue in Designer View

  Hi folks....I'm back, After searching and trial and error, I've hit a brick wall. I want to add a Public Variable as the DefaultValue of a Column in a new DataRow. In the DataSet Designer Properties, how do you insert a variable name into the field for DefaultValue Is this possible or are you constrained to putting only a String in as DefaultValue Thanks much. hi, open your double click your dataset in solution explorer, and select any column from your table , go to properties you will find datatype property and default value property, set the default value depending on the datatype ...Show All

• Windows Forms mess up lisbox during looping.

  I don't know if it's a bug or not but i have a listbox with some items in there. on the click event of the listbox i put a while loop. what happens is that the listbox automatically highlite the last item. You can test that on ur VS2005. Is there a way to fix that "i put a while loop". Please show us the loop so we can test it too. ...Show All