New Programmer's Q&A profile
SQL Server Trimm off any extra spaces in File Connection Manager for a field
I have a field that in my File connection manager is set to 4 as the column width. Only about 50% of the time will that field have 4 chars, and 50% of the time it will be 3. The problem is that when it's only 3, my flat file that is produced obviously then has an extra space between this field and the next which can't be allowed. Is there any way to tell that field to trim off that extra 4th space if it's not all filled when a record is written to the flat file how do I do this No, it is not possible with a fixed width or Ragged-right format. There is no way to trim off that extra space.Not sure what your requirements ...Show All
Windows Forms refresh() method
Whye does the refresh method cause the controls on the panel to "shake" and flimmer Anyone have a solution for this Hmmm...I think the problem only relates to groupboxs. Other controls looks to be ok... ...Show All
Visual Studio Team System Need to install VS Client part
Hi All, I want to install Client part of VSTS in my local machine. Can anyone give me the location from where i can install that. Also Configuration of the client machine required. Thanks in advance Mousumi Sahoo Hi All, I want to install Client part of VSTS in my local machine. Can anyone give me the location from where i can install that. Also tell me what configuration is required for the client machine. Thanks in advance Mousumi Sahoo ...Show All
SQL Server Move table
How can i move tables from one database to another without losing any of the PK, FK or the identity column constraints I currently use wizard and thought maybe you can do this with some Tsql code... Is it possible Thanks for any help You can do the following in TSQL: 1. Use SELECT INTO to create the tables with data (identity property of column will be copied over including the NULLability constraints) 2. Add the constraints using metadata from INFORMATION_SCHEMA.TABLE_CONSTRAINTS, CHECK_CONSTRAINTS etc. 3. Create defaults, computed columns using syscomments information In SQL ...Show All
SQL Server file attribute using a control
I have managed to capture the file path through some SSIS tasks. Now I am looking to read get the File Name present for a file in this path. How can I possibly do this Do I have to use the script task and write something up in VB.NET Hope there is an easier way out. I have been trying to figure out the File SYstem task. But that seems really complicated as well. Please let me know. This is an emergency for a special DEMO. Thank you!!! Script task is the way to go. Getting file name from full path is as simple as System.IO.Path.GetFileName(path); ...Show All
Visual Studio 2008 (Pre-release) Color Animation Problem
hi I want to apply a color animation on my rectangle when I move my mouse over it. But I get a runtime exception when I attempt to do the same. This is what my xaml code looks like- <Rectangle Name="R1" Fill="Aqua" Width="100" Height="50" Stroke="Black" Margin="200"> <Rectangle.Triggers> <EventTrigger RoutedEvent="Rectangle.MouseEnter"> <EventTrigger.Actions> <BeginStoryboard> <Storyboard> <ColorAnimation Storyboard.TargetName="R1" Storyboard.TargetProperty="Fill" To=&quo ...Show All
Visual Studio Team System "Latest" with MSBuild
What's the best way of getting a "Latest"-folder for builds performed by VSTS I guess this involves changing the TFSBuild.Proj-file, but I also guess someone else has done this before me... Thanks! gunman69 wrote: " Which brings me to a broader question - is there an exhaustive list of well-known variables " You can find the variables available to you by changing the TFSBuild.rsp for your team build so that it contains a line as follows: -v:diag Check that file in and then run the build and you should find that your build log contains a full list of all of the variables (and their values) at the start. ...Show All
Visual Studio 2008 (Pre-release) MIME type for .wba
What is the MIME type for Avalon Express Applications (.wba) For Beta 1 you had to add application/x-ms-xapp MIME type for .xapp From the SDK for September CTP (look for 'Configuring a Web Server to Deploy WPF Applications'): Extension MIME Type .manifest application/manifest .xaml application/xaml+xml .application application/x-ms-application .wba application/x-ms-wba .deploy application/octet-stream ...Show All
SQL Server Parameters will not Default
Greetings I am using SQL 2005 Reporting Services and I have a problem with parameters. If I leave 3 of the 4 values as non queried in the Available values section and mark them as a Default Values: of NULL, then the report works fine. However if I set the Available values to a query I have written and leave the Default values as NULL, when I view the report in either preview mode or on the reports server, it wants me to specify a value from the boxes and the tick box for NULL has disappeared. Allow NULL value is ticked inthe first section, Properties. Anybody got any suggestions If you have available values, then the allowable v ...Show All
Windows Forms How do i assign this?
let say i wanted to sum up all the price in my database and assing it to a listview table. how do i do it what i did was .... myRS.Open("Select SUM(Price) FROM Store",myDb) how do I assign it to a listview where does the value store actually I don't understand what you are trying to do... So far I've go ...Show All
Visual Studio Team System Build Succeeded, but no output.
Hi, I'm just trying to build my simple web application with Team Build. I was managed to create new build type. But when I'm running the build project, I'm getting only 3 files (BuildLog.txt, ErrorsWarningsLog.txt, Mixed PlatformsDebug.txt) in my drop location. My build log says, 1 Warning, 0 error. What can be the problem Here is my build log: Build started 6/15/2006 10:33:38 AM. __________________________________________________ Project "d:\buildsample\Team Proj1\MyTestBld\BuildType\TFSBuild.proj" (EndToEndIteration target(s)): Target InitializeEndToEndIteration: UpdateBuildNumberDropLocation BuildNumb ...Show All
Smart Device Development How to use C++ in project Net Compact Framework
Hi all, I am new with Net Compact Framework.Cos i always use evc++. Hope that i don't make some stupid question. Now i need the graphic ( with button, colors, everything like that ). In vs2005 beta 2,for vc++ it supports only MFC.So it's not interesting like in win32 where we can use Qt. So my question is that: can i use c# with net compact framework to make an interface graphic user, and use C++ for the other Cos in C++ project i can use C with keyword, extern "C", it exist with extern "cplusplus+" or extern "C" in project C# Thank for reply. Julien T Julien, You can call from C# into a C dll via the PInvoke mechansim. Here is a link ...Show All
.NET Development system.objectdisposedexception
Hi, I have a multithreaded application that crashes with the following msg in event log ... EventType clr20r3, P1 smartserver2005.exe, P2 1.0.0.0, P3 43f6cc52, P4 system, P5 2.0.0.0, P6 4333ae87, P7 3ad8, P8 a5, P9 system.objectdisposedexception, P10 NIL. I have provided try catch block in all routines in the code & still the appl crashes with the above msg. Note that crash is not consistent for a particular sequence of events. Any suggestions -S.Malathi Hi! It appears that one of your threads Dispose() some object and another reference this object later. Disposing doesn't mean obj ...Show All
Visual Studio knowledge of classes within project
How does Visual Studio know about Classes within a project For example if I had 2 source files, each being a class library, Class1 and Class2. If I add an instance of Class2 in Class1 intellisense knows about Class2's constructor, methods, etc. I'm wondering if this will be a problem with the Package we are creating that contains our own proprietary language. Currently we call an assembly that uses reflection on the project references to validate the objects used in the program. How would we validate objects used by other source files in the same project We have the same requirement for a custom langua ...Show All
Windows Search Technologies Using a mapped drive to install and use a videogame
I need help. I have a laptop that the dvd drive has died on. everything else works but the dvd drive. Since the dvd drive no longer works I have not been able to play any of the games I have installed on it(most games require that you insert the game disc to play). What im trying to figure out is if I can use a mapped network drive to get around my broken dvd drive on the laptop. I have already mapped a drive on my laptop that connects to the dvd drive on my home computer. I was successfully able to use this drive to install diablo. However when I trie running the game it displayed the message "please insert the diablo disc and click ok ...Show All
