Chirurg's Q&A profile

• SQL Server T-SQL Select Statement executed inside the Visual Studio 2005 Environment returns -1 for the "True" Values of the bit fields

  T-SQL Select Statement executed inside the Visual Studio 2005 Environment returns -1 for the "True" Values of the bit fields of any table. The database is SQL Server 2005. When I execute it inside the SQL Server management Studio I receieve 1 for the "true" values.   I think this is a bug. Hello, I have added "Database Project" to my solution, so I want to be able to execute some statements without starting the SQL Ser ...Show All

• SQL Server Scripting: Dumb Q.. How can I store a DTS variable inside a script variable?

  Hi I want to pass in a variable to a script, store it's contents in a varaible, increment it by one and pass it back out.   This sounds pretty easy but I'm struggling finding any good docs on how to pass in a dts variable and store it.  The script component is called within a control Flow, foreach loop container.  I wanted to count each time the loop picked up a file to work with and store the results in a variable to be lat ...Show All

• Windows Forms Windows form not closing???

  Hi I am trying to close the form by clicking the X but the window is not closing..... The window is closing when I click the exit menu which calls this.close function..... I have a form A where I added form B to the panel. Form B has& ...Show All

• Visual C# Setup Set Version and Install Overwrite Properties

  I managed to do this once, but never again In a VS2005 Setup project, by some combination of actions, I was able to get to a properties list that allowed me to directly set the Version Number and the flags that forced the setup project when compiled to overwrite any pervious version (for sllent install running under administrator role) on the users system. Can anyone help me to know how to access this property list. Thanks Hi, ...Show All

• SQL Server Regarding MergeReplication-Tutorial

  Hi Forum-Members, I was doing the Step by step tutorial "Developing a SQL Mobile Application with Visual Studio 2005 and SQL Server 2005". Link: http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnppcgen/html/med302_msdn_sql_mobile.asp Doing it on Windows XP (as required by the tutorial) worked fine for me, doing it on a Windows Server 2003 installation failed, as the client could not connect to the SQL Server database. Does anyon ...Show All

• .NET Development How to know when a CAO client has close?

  I am using a CAO schema in a remoting scenario. I need to know when a client has close the app. It's a chat, and I need to know when clients close, so I report the session termination to the other clients. Any idea Do u know about another schema wich could work better than CAO I dont like singleton cause i cant have individual info for each client since they share the same object. Thx in advance. you're welcome. ...Show All

• Visual C++ How to use function AfxCheckMemory()

  Hi, A few days ago I posted a message about problems with my c++ project: it gave different results depending on the location from which it was run. So far, we haven't managed to solve the problem; however, we think there might be some memory problems. According to the help index of c++ (version .NET 2003), I can use AfxCheckMemory() to check the code for memory overwriting during runtime. When typing this text in the code, it is indeed re ...Show All

• Visual Studio Team System TFS Beta3 Upgrade - Lost projects??

  I have recently upgraded to Beta 3 refresh. Everything went OK eventually. >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> 1. moving the data tier along with Beta 3 refresh. I've backed databases on old data tier and attaching them on new data ...Show All

• Visual Studio Team System Test run name and test list

  Hello All, I have some tests list like Release 1 Iteration 1 TU        (stands for Unit Tests) TR        (stands for Acceptance Tests) Iteration 2 Release 2 ... I would like to run first all my Unit Tests and then all my Acceptance Tests. If I reorder my tests lists to have something like TU Release 1 Iteration 1 It ...Show All

• Windows Forms ??record video stream??

  I am doing a project,trying to record a video stream from a network camera(AXIS 211),and i'm using visual basic .NET 2003 Windows Application. Now i'm stuck, no idea how to start. Does anyone know how to record a video stream from a network camera in Windows Application ~THank yOu very Much~ i'm using (for images) Windows Image Acquisition Library, i don't know if it works even with video streams. HTH   ...Show All

• SQL Server Replication Deadlocks

  Hi All, I need to get some assistance with some replication deadlocks im getting. We have two servers, which push information between each other, which I have a hunch could be a cause. Basically I keep getting the 'Agent Retry' Alert from SQL: DESCRIPTION: Error: 14152, Severity: 10, State: 1 Replication-Replication Distribution Subsystem: agent SQ01-EMS-SQ02\UK-183 scheduled for retry. Transaction (Process ID 68) was deadlocked on lock re ...Show All

• Windows Forms Reduce SPACE

  Hi vevery body How I can reduce space between the items of a listview if that listview is in LargeIcon view. Thanks ...Show All

• SQL Server Execute a SSIS master package through an ASP.NET web app

  I am trying to execute a SSIS package via a web application built in c#.  I found a sample to read the output of a data flow task, but I'm stuck.  If I build the command line syntax for the package, create a DtsConnection object and set the connection string to the syntax, what else do I need to do   Thanks. Clay A call to the Variables collection with an index or name will return a Variable objec ...Show All

• Windows Forms Adding BLOB images to a ImageList

  Hello all, I'm using the code below to read a BLOB from a sql table and add it to an image list. When i run the code, i receive a "Parameter is not valid." error message. Anyone see anything wrong Dim myReader As SqlDataReader Dim mySqlConnection As SqlConnection Dim mySqlCommand As SqlCommand Dim ms As New MemoryStream() Dim im As Image = Image.FromStream(ms) 'ms.Close() 'OwnList ...Show All

• Visual Studio Express Editions ListView sorting question

  Hi I have a ListView control called HSlist on a form which has 3 columns. The adding data seems to work OK, but the sorting is weird to say the least. Initially, I thought that the list would be sorted on the contents in the first column, so I added to the ListView with the Item containing the data that I wanted the list to be sorted on (numerical). Then I found that the list was being sorted on the second column (strings), so I swapped th ...Show All