kcchesnut's Q&A profile

• SQL Server Help on one colum

  Hi, I have a column in SQL that needs to be created. This column needs to start with 10 zero's. If I add a number, say 135 the column needs to read : 0000000135. Is this possible If it is how do I need to go about to do this. If I need to create a view or something like that I do not mind. I am open to all suggestions and appreciate the help. Use the following query.. Select Replicate('0',10-len(Convert(Varchar,ColumnName))) + Convert(Varchar,ColumnName) From TableName ...Show All

• Visual Studio Team System Uninstalling Team Foundation Server

  Somehow my instance of Team Foundation Server is corrupted. I am unable to repair/reinstall or uninstall Team Foundation Server. When I try to do any of these operations, the installation dies and when viewing the Setup.log I see the following error: DepCheck indicates Microsoft Visual Studio 2005 Team Foundation Server - ENU is not installed. How can I get TFS to uninstall Thanks. Yes I am still having problems. It is a single box install. My boss is on my case about it because the application log has nothing but TFS Services errors in it. ...Show All

• SQL Server Day of the month

  I am trying to code a proceedure that will run every weekend. This process will run for a number of hours beginning at 0900 Saturday and ending at 2100 Sunday. However, on the 3rd weekend of the month, I need it run for a shorter time and to also skip some tables. What I have now to find the day of the month I need is Begin SET @3rdSaturday = @1stDayMonth /*Loops until the date of the first Saturday(DayofWeek #7) of the current month is found */ WHILE DATEPART(dw,@3rdSaturday) <> 7 /*Adds 1 day to the first day of the month until it reaches the date of the first Friday of the month */ SET @3rdSaturday = DATEADD(d,1,@3rdSaturday) /*Adds 14 days to the first Friday of the month. The end result is the 3rd Fridays date ...Show All

• Visual Basic How to a long line into 2 lines?

  I forgot... I think u need to type something close to this: [first half of line] +_ [2nd half of line] Couldn't google it :( could someone remind me. This is what I want to do: messagebox.show( "Very very very very very very very very very very very very very very very very very very very very very very very very long line" ) That would run off my screen... I know theres a way to bring that down to a 2nd line. I know theres wordwrap... but for what I'm trying to do... the above would really help. ...Show All

• Windows Forms Accesing selected text in other application

  I'm running a Tray Application which gets on focus when a hotKey is pressed. In a few words, the user will select a piece of text in any application (IE, word, acrobat, or any custom application), press the hotkey registered by my application, and the application should be able to read and display the selected text. Could anybody guide me to accomplish this Is it possible Thanks, Seb. That's a great idea... I'll need to research about using the winapi cause I never did anything like this before. I will be using c#, but need a lot of work before posting something.. Thanks MadAboutC# !! ...Show All

• .NET Development Getting Indentity field (Id) when INSERTING og UPDATING DataSet to SQL Server

  I have an applikation that uses DataSets, i fill my datasets using an SqlDataAdapter and the Fill method. When i have new data to save in the database, Ii create a new dataset with the values needed, the I use the Update method on the SqlDataAdapter to save the data in the db. To get my INSERT statement I use the SqlCommandBuilder.GetInsertStatement method. This works fine, but I would like somehow to get the Indentify (in my case named Id) field for the row inserted (or updated for that matter). How is this possible -- Sparre The link I posted contains an example which uses an output parameter and SCOPE_IDENTITY to fetch the value. Did you give that try ...Show All

• .NET Development SQL2005 & VB.NET 2005

  hi i have a question,i can connect to a sql server 2005 database and get results but when i want to insert records to my database,i dont get an error but it doesnt update!!! Dim conn As New OleDbConnection( "Provider=SQLNCLI.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=mylibrary;Data Source=IBRAHIM-6740DDE\SQLEXPRESS;" ) Dim ds As New DataSet Try conn.Open() Dim com As New OleDbCommand( "INSERT INTO bolumler(adi,altbolumadi,kayittarihi) VALUES ('" + TextBox2.Text + "','" + TextBox3.Text + "','" + DateTimePicker1.Text + "')" , conn) conn.Close() Catch ex As OleDbException MessageBox.Show(ex.Message) Catch j ...Show All

• Visual Studio VS2003 Hangs when I try to 'Build' or 'Rebuild' my project

  My VS2003 hangs whenever I try to compile any project. Even if it is just a simple hello world type program. This started happening when I tried to install the Service Pack for VS2003 and it didn't work. Please suggest how I might repair VS. Thanks. Okay, reinstalling the Components disk helped. I think that took care of it. Thankfully, I did not need to do a full re-install of VS 2003. Just the Components disk. Now the question is, do I try to install the VS.NET 2003 service pack again Thoughts on this please. ...Show All

• Visual Studio sgen.exe failed due to spaces in keyfile's path. How can I work around this?

  sgen.exe is getting called like this (complete outout can be seen if necessary, only putting here relevant info: [vmsbuild] C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\bin\sgen.exe /assembly:"c:\Documents and ....dll" /proxytypes /compiler:"/keyfile:c:\Documents and Settings\dansan\My Documents\src\ProjA\060608-FixScripts\SolutionFile s\Development.snk" /compiler:/delaysign- [vmsbuild] The "SGen" task is using "sgen.exe" from "C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\bin\sgen.e xe". [vmsbuild] Microsoft (R) Xml Serialization support utility [vmsbuild] [Microsoft (R) .NET Framework, Version 2.0.50727.42] [vmsbuild] Copyright (C) Microsoft Corporation. All rights ...Show All

• Visual Studio 2008 (Pre-release) Message and Trace logging rollover

  I'm interested in using the message and trace logging functionality built into the WCF framework. Does anyone know how to configure it so the log file can rollover on a daily basis in a way similar to logging on an IIS web site Tracing in WCF is built upon the trace listening facilities in System.Diagnostics; there are a couple of rolling file trace listeners available on the web that could be used for your intended purpose. Here is one example: http://bloggingabout.net/blogs/erwyn/articles/rolling_file_trace_listener.aspx . Dave ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Game State Class - Sharing Information

  I'm using the default XNA game template for the time being, as I'm not intimate with C# yet. I'm trying to set up a game state stack, using a class derived from the game class. The GameState class has UpdateMe and DrawMe functions that basically call protected methods Update and Draw in the Game part of the inherited class. I also have a gameState handler class that has a stack of GameState objects that it keeps track of, etc. If I use this encapsulated method of game states, how do I share information between game states. For instance, if I have a menu screen that shows character info, how do I share the character's stats between the main game state and the menu state. I figured using static class members was a bit crude, but I'm unsure o ...Show All

• SQL Server Package Configurations not so portable?

  I'm still struggling with finding a sound approach to creating configurations that are truly portable.  For instance if you use XML files to store configuration information, the path to the XML file that stores the configuration is baked into the package.  This would require the same file system structure on all machines that could host the package. Store in SQL server - one key thing that is valuable to configure is Data Sources - but how can you configure a data source at runtime by storing it as a config in SQLServer, when the data source itself is used to specify the server that stores the config information Environment variables or registry entries seem to be the most practicle because they truly are machine specific. ...Show All

• Visual Studio Express Editions A marketing gimmick

  I have not been able to register the visual basic express software also. It keeps telling me invalid email. I am beginning to think it is just a marketing gimmick. It is not a marketing gimmick but it seems microsoft is having some issues with the registration process. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=567005&SiteID=1 You probably need to update your profile manually by going to http://profile.microsoft.com ...Show All

• Visual C++ IUnknown::Release() not working when called from a different thread then AddRef() was called

  Ok...   My situation is that I have a group of Objects that inheirit from CCmdTarget.  Therefore, these object's methods are exposed via COM. My problem is releasing some of these objects.  For some objects everything releases smoothly. I call myObject->Release() during the deconstruction of my thread object (a closing socket connnection). But when shutting down my system I am in the base thread trying to deconstruct my objects and when I call myObject->Release() it does nothing. THis is leaving me with memory leaks. Any sugguestions   Thanks Have you checked the component's apartment model Anyway im not an expert in that technology. ok let me tell one thing. According to Scott Meyers (Author of ...Show All

• .NET Development Wrong link to Visual Studio 2005 extensions for .NET Framework 3.0

  It seems to me, that link http://www.microsoft.com/downloads/details.aspx FamilyId=5D61409E-1FA3-48CF-8023-E8F38E709BA6&displaylang=en points to SDK, and not to Visual Studio 2005 extensions for .NET Framework 3.0. I ran into the same problem. The installer you linked to is for Visual Studio 2005 Extensions for Windows Workflow Foundation. It looks like there is either a problem with the self-extracting archive or the temp directory is not being cleaned up properly after the SDK installation. If you use WinZip to manually extract the file (Visual Studio 2005 Extensions for Windows Workflow Foundation (EN).exe) and then run Setup.exe from there, everything works fine. Sean ...Show All