ChopKiwi's Q&A profile

• Visual Studio Express Editions SQL database

  hey guys, im just learing how to program...im working through bob tabors tutorials for visual basic 2005 express edition. im on lesson 8 which starts to deal with SQL databases. the problem comes when ive added a new database and when i add a new table and start uptting in information, i cant set a "primary key". the button for doing this is greyed out, as are all the other buttons in the "table designer" toolbar. does anyone have any ideas why all the buttons are greyed out thanks for any help! If you have set focus inside the table designer, then, the icons should be enabled.  I'm not exactly sure ...Show All

• Visual Basic Read records from one table and insert ID into another problem

  I have two tables. 1 is nonCash that has the following records: ncID=1, cat=VISA, postn=1, ctryID=1 ncID=2, cat=Check, postn=2, ctryID=1 ncID=3, cat=Money Order, postn=3,ctryID=1 The second tables is nonCashAmt with fields: 1) ncAmtID - PK 2) processID - Index 3) ncID - Index 4) amt 5) remarks processID, ncID combination is unique. I was trying to datareader to find all the records in nonCash where ctryID=1, and insert them into nonCashAmt. When using the while loop to read, I can't do another query to check if processID=1, ncID exist or not. If it does not exist, I want to insert, if exist, then I skip the insert and check the n ...Show All

• Visual Basic SQL Help !

  I have a store Procedures and vb code as below. The problem is i just can't get the data out of this parameterised storeprocedures. Does anyone have any idea about this Or is there something wrong with my code below After few experiment, I found that I got no error on returning numeric value. But problem with returning character value. Is there any other way to do this CREATE PROCEDURES GETTest     @TESTID BIGINT,     @TESTName VARCHAR(50) OUTPUT,     @TESTType VARCHAR(50) OUTPUT,     @TESTValue VARCHAR(10) OUTPUT AS SELECT @TESTName = TESTName,   &nb ...Show All

• Visual Studio Tools for Office Outlook 2003 navigation bar

  Hi, Ive got some questions regarding Outlook 2003 development. I am using VS 2005 Beta 2 and VSTO 2005. What Id like to know is what level of customization is possible in modifying Outlook. For example, can I create a new button and add it to the navigation bar If I then click on my button can I view a custom top level form similar to say the calendar or contact list Is this possible and if so which objects should I be looking at Thanks, Mike Hi, I didn't find how to add a Navigation Bar to Outlook. I read in another post that is not possible. 1 - Anybody have an example about how to add a new option ...Show All

• SQL Server Obtaining TCP/IP Port and Pipe name

  Hello All, Does anyone know how to obtain the TCP/IP port and the pipe name for an instance I would have expected to see these properties in smo.server.configuration or smo.server.settings. What am I missing here Thanks Rob Take a look at Microsoft.SqlServer.Management.Smo. Wmi .ServerInstance. ServerProtocols property is a collection with information about each protocol settings. WBR, Evergray -- Words mean nothing... ...Show All

• Visual Studio Team System error loading custom rules to FxCop v1.32

  Hello , I am trying to add certain custom rules to fXCop v1.32. I had developed these for FxCop v1.312. The exception message i get while trying to load these rules to FxCop v1.32 is One or more of the types in the assembly unable to load. The LoaderExceptions Array reads: System.IO.FileLoadException: The located assembly's manifest definition with name 'FxCopSdk' does not match the assembly reference. File name: "FxCopSdk" === Pre-bind state information === LOG: DisplayName = FxCopSdk, Version=1.312.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35  (Fully-specified) LOG: Appbase = C:\Program Files\Microsoft FxCop 1.32 Be ...Show All

• SQL Server Performance Hit after upgrading to SQL 2005

  I am hit with bad performance after upgrading my sql 2000 to sql 2005 version. All the infrastructure remains expect the performance :( Please provide any pointers /guidelines so that I will check the same. Thanks in Advance Varun I am seeing a huge performance problem right now. I have to tagged to the TempDB right now. It seems to be leaving leftover objects and making the TempDB a mess. Check yours for a bunch of "#" + 8 digit Hex If I stop and restart my SQL Services, which redoes the TempDB....I am good to go for a day or 2...then the same old problem. I have called MS about th ...Show All

• .NET Development Is WS-ReliableMessaging implemented in .NET 2.0?

  Hi, Can I download the extention or source code for WS-ReliableMessaging Thank you, Alan Hi Alan, Take a look at the following links: WSE 3.0 and WS-ReliableMessaging http://msdn.microsoft.com/webservices/default.aspx pull=/library/en-us/dnwse/html/wseandws-rm.asp WSE 3.0 June CTP - Works with VS2005 Beta 2 http://www.microsoft.com/downloads/details.aspx FamilyId=7591DFD2-E1B7-4624-9D5B-29C211D149FE&displaylang=en Regards, Vikram ...Show All

• Visual C++ Where is uuid.lib in VS .NET 2003?

  Hi Dennis! Does anyone know how to either: 1. remove the uuid.lib dependency (I cannot figure out where it is coming from) 2. download uuid.lib It should be in the following directory: %ProgramFiles%\Microsoft Visual Studio .NET 2003\Vc7\PlatformSDK\Lib -- Greetings Jochen My blog about Win32 and .NET http://blog.kalmbachnet.de/ Dennis, It is possible you simply need to add the PSDK to your include paths. Thanks, -- Boris Jabes, Visual C++ Team This posting is provided "AS IS" with no warranties, and confers no rights. ...Show All

• Windows Forms How can I add mainmenu items on Treeview control?

  Hi friends I want draw my mainmenu items on Treeview. How can I do that Thanks I have a sample code for VB.Net it is : Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As  System.EventArgs) Handles Button1.Click         Dim mnu As New MainMenu         Dim tn As TreeNode         Dim&n ...Show All

• Visual Studio Express Editions Printing a form

  After following the code found here   to print a Windows Form I now have this Dim memoryImage As Bitmap Private Sub CaptureScreen() Dim myGraphics As Graphics = Me .CreateGraphics() Dim s As Size = Me .Size memoryImage = New Bitmap(s.Width, s.Height, myGraphics) Dim memoryGraphics As Graphics = Graphics.FromImage(memoryImage) memoryGraphics.CopyFromScreen( Me .Location.X, Me .Location.Y, 0, 0, s) End Sub Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click CaptureScreen() PrintDocument1.Print() End Sub Private Sub ...Show All

• Visual Studio 2008 (Pre-release) InvalidProgramException

  Hello guys, I am trying to create my own program using Linq. I am using VS 2005 Beta 2. I have installed the required css compiler for C# 3.0 and also installed the IDE support for C# 3.0. When I compile the program I am getting no errors and the build is successful. When I run the program I am getting InvalidProgramException. When I am trying to run the Samples downloaded from msdn web site, its working fine. I am getting problem when I am trying to create my own project and run it. Do I need to configure something Please some help me. Thanks in advance. Koti. Hello guys, I figured out my mistake. I have opened a normal Console ...Show All

• .NET Development Keeping a service running

  I have an app that was originally written as a WinForms app that I need to convert to a Service. Most of that work is done, but I'm running into one last problem... The app was architected such that it creates N instances of a class. The class instances do all the work, and the WinForm app just listened to a particular event to give feedback. In the original app, the WinForm Message Pump loop kept the app alive, but now that its a service, it doesn't stay alive. IE, when the service starts, it creates the instances of the class, then exits. And once that main thread exits, the whole app exits. How do I keep the main thread alive I'm assu ...Show All

• SQL Server Corruption of package?!

  I have done this twice - grrrr! Simple SSIS package contains the following tasks Control Flow 1. VB .NET Script to create a file name with "sometext" + mmddyy + ".xls" 2. FTP Task - logs into FTP site, finds file name created in 1) and downloads 3. Data Flow Task Data Flow 1. Excel Data Source - connects to and maps the Excel workbook/sheet columns 2. OleDB Destination - Inserts rows using the column mappings from 1) above 3. Error Flat File - connects to existing ".txt" file and logs rows not processed. The only non-routine thing is to go into the Excel Connection Manager (default name) and use the expression buil ...Show All

• Visual Basic Mixed string and numeric record I/O

  I'm looking for a VB 2005 example of reading a non-text file into a structure and writing from it; basically record I/O. In VB 6 I defined a record like Type CRecord CName As String * 15 CDesc As String * 34 CNuTp As Integer CNuRs As Integer COnOf As String * 1 End Type and opened the file as Random and read the records into a buffer with the CRecord type. I can't find any example of this in the VB 2005 help system, and when I try the auto-translated version I get a "read past end of file" error on the first record read. I suspect the problem is with the Structure that replaced the Type to define the record, and may ...Show All