Steve Eichert's Q&A profile

• Visual Studio Team System SOAP Event, Failed to deserialize the eventXml for WorkItemChangedEvent

  Hi all, I'm writing a WebService to get notifications about the state change of the Work Item. I'm almost there, when a state is changed, my Notify() method is called, and the eventXml contains the XML info about the WorkItem. I wanted to create a C# object from the XML string, so I used the XSD.exe tool with the xsd delivered by Microsoft to create a new "WorkItemChangedEvent" class. The .cs file was generated successfully, but when I attemp to create my object like this: public void Notify ( string eventXml ) // Do not change the names of these parameters { XmlSerializer xs = new XmlSerializer ( typeof ( WorkItemChangedEvent )); StringReader sr = new StringReader ( eventXml ); WorkItemChangedE ...Show All

• Visual Studio Express Editions ExecuteNonQuery doesn't work

  Hi, // Connection SqlConnection MyConnection05 = new SqlConnection(); MyConnection05.ConnectionString = "server=localhost;trusted_connection=true;database=tscfin_19"; string sCommand05 = "insert into xpto values( 1 )"; //Open MyConnection05.Open(); SqlCommand MyCommand05 = new SqlCommand(sCommand05, MyConnection05); //Execute MyRow = MyCommand05.ExecuteNonQuery(); // Close MyConnection05.Close(); MyRow is 1, but I can not see the row in the database I didn't add the database on the project,because is a console application. I think that I don't need to add. I just want to connect and insert 1 row. thanks Does this SQL work if you enter it into the database I don't see anything wrong with thi ...Show All

• Visual Basic Opening csv files through web

  Hi, I'm using the following code to open a csv (comma separated values) file over the web. The problem is, when Excel opens the file, it puts each line in the first cell of each row, completely ignoring the commas. I tried using other content types, but they all do the same thing. Any help would be great. Thanks. <% Response.buffer = TRUE Response.ContentType = "application/x-msexcel" Dim vntStream Set oMyObject = Server.CreateObject("MyObject.BinRead") vntStream = oMyObject.readBinFile("c:\temp\tempcsv.csv") Response.BinaryWrite(vntStream) Set oMyObject = Nothing Response.End %> Function readBinFile(ByVal bfilename As String) Set oFSO = CreateObject("Scripting.FileSystemObject") ...Show All

• Visual C# File IO for struct

  I need a bit of help on File IO using structures (I'm somewhat new to C#). My struct consists of various elements. Here's an example: public struct BoxRecord { public bool BoxEnabled; public string BoxNo; public string CustomerName; public string Contact1; public string Contact2; public bool SendMsgArrival; public bool SendMsgRetreival; public byte SensorRow; public byte SensorCol; } I have 64 of these records and have declared a database: public static BoxRecord [] BoxDatabase = new BoxRecord [64]; Now I need to create, write, and read a disk file for this database. Am I heading in the right direction Comments & suggestions welco ...Show All

• .NET Development Error while running an Asynchronous Server/Client

  Im running a simple Server/Client application using TcpListener and TcpClient for (asynchronous) connecting and NetworkStream for asynchrous sending and recieving. When i try to terminate a client, the server and all other clients crash and give this exception: Attempted to read or write protected memory. This is often an indication that other memory is corrupt. " at System.Net.UnsafeNclNativeMethods.OSSOCK.WSAGetOverlappedResult(SafeCloseSocket socketHandle, IntPtr overlapped, UInt32& bytesTransferred, Boolean wait, IntPtr ignored)\r\n at System.Net.Sockets.BaseOverlappedAsyncResult.CompletionPortCallback(UInt32 errorCode, UInt32 numBytes, NativeOverlapped* nativeOverlapped)\r\n at System.Threading._IOCompletionCa ...Show All

• SQL Server Security problems in the initial synchronization

  Hello everybody, I would be thankful if you try to help me with my problem, I am using merge replication under SQL Server 2005. In our system there is a central database running SQL Server 2005 Enterprise Edition with a big database published for merge replication. There are too a lot of clients running SQL Server 2005 Express Edition that pull subscriptions to the central database. How the clients create subscriptions and run the synchronization process is posted below (RMO Progamming). When running the syncrhonization process, the Distributor connects OK, the Publisher Connects OK... but when the snapshot copy process starts, the execution is halted with an init session error "unknown user name or wrong password" (more ...Show All

• Windows Forms Best way to close Windows Forms?

  Hi all, I have an application that uses Dialog Forms, and want to know the best way to close forms down in my application. If I have the following code in my application that runs when a button is clicked, which opens up a form, and then have a Click event on the newly opened Form that closes the form - is the correct (most efficient) way of doing this // Button was clicked to open new Form. private void NewForm_Click(object sender, EventArgs e) { FormSnagV1 frm = new FormSnagV1(); if (frm.ShowDialog() == DialogResult.OK) { frm.Dispose(); } } // Button was clicked to close the Form. private void mnuItemCancel_Click(object sender, EventArgs e) { DialogResult = DialogResult.OK; ...Show All

• Visual Studio Team System why I got different sizes of the *.msi file every time I compiling the setup project?

  Hi,All I create a setup project in VS.net 2005. Every time I compile the project file xxx.sln. I got a xxx.msi file with different size with the previous one. Is there anyone know what's the problem Thanks. ...Show All

• SQL Server Reusing package configuration in child packages

  I currently have multiple (parent and child) packages using the same config file. The config file has entries for connections to a number of systems. All of them are not used from the child packages. Hence, my child package throws an error when it tries to configure using the same config file because it can't find the extra connections in my connection collection. Does anyone have any ideas on the best way to go about resolving this Is multiple config files (one for each connection) the only way Sachin Nice idea, support for XML Inclusions (XInclude) would do it ( http://www.w3.org/TR/xinclude/ ). One for MS Connect I think - http://connect.microsoft.com ...Show All

• SQL Server OLAP cube - errorhandling

  Dear all i have inherited a SSAS 2k5 cube with a large number of calculated members. I have a number of problems: sometimes the calculated amounts are very very small like: 0.00000000000034. This however, does not play nicely with excell... heximal display and so on. anyone know of a way to show these as being 0 secondly I have a number of calculated members who themselves contain calculated measures. When one of their parents is 0, they resort into div/0 erros, etc For my current project it is unacceptable that these errors are visible for the end user is there any way that i can catch all the errors at once or do in eed to include iif statements in the calculations of each calculated member Hi, unfortunat ...Show All

• SQL Server Replication Issue with Dynamic Filter using HOST_NAME()

  Dear ppl, I am having a couple of problems with using dynamic filters in Merge Replication (SQL Server 2005 - SQL Mobile) 1) I am trying to add a dynamic filter to my publication using the wizard as follows: SELECT <published_columns> FROM [dbo].[Audit] WHERE AuditorID = CONVERT(int,HOST_NAME()) This gives me an error Conversion failed when converting the nvarchar value 'MSSWS02' to data type int. because my computer name cannot be converted to an integer. After reading on http://msdn2.microsoft.com/en-us/library/ms152478.aspx I have found that it has been recommend specifying CONVERT(nchar,AuditID) = HOST_NAME() in the wizard and then use sp_changemergearticle to change the clause to AuditID = CONVERT(int,H ...Show All

• Visual Studio Team System 3 of 4 project alerts works

  For some reason, I am not receiving any emails for the "Anything is checked in" project alert. I am receiving emails for "My work items are changed by others", "A build quality changes", and "A build completes" but not the checked in alert. All 4 alerts are enabled and I am using the same email address for all 4 alerts. I am currently using v1.0 of Team Foundation Server. I checked the log, and I believe this is the problem: [Info, PID 1888, TID 3828, 15:07:45.217] Calling notification filter: Microsoft.TeamFoundation.VersionControl.Server.CheckinEventFilter [CS] [Info, PID 1888, TID 3828, 15:07:45.342] Found restrictions: Microsoft.TeamFoundation.VersionControl.Server.CheckinEventFilter [I ...Show All

• SQL Server Full Text Search Weighted Question

  Hello, I have the following query: USE test SELECT new.[key], new.rank, test_Class.Manufacturer, test_Class.Model, test_Class.Title, test_Class.Description FROM test_Class INNER JOIN FREETEXTTABLE(test_Class, (Manufacturer, Model, Title, Description), 'Logan') AS new --CONTAINSTABLE(test_Class, (Manufacturer, Title, Description), 'Logan Magnolia') AS new --FREETEXTTABLE(test_Class, (Manufacturer, Title, Description), 'Logan') AS new on test_Classs.Class_ID = new.[key] ORDER by rank desc I want to have the search work so that if the word logan is in the Manufacturer Column it has a higher rank than if it apeared twice in the description. Basically I want to weight the colomn instead of specific words in the search, which I know how to do. A ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. How did you start out in the world of programming?

  I apologize if this is inapropriate, but I just wanted to ask something. For those of you who have proffesional experience in game programming, what was it like for you to start out And what is some wise advice that a begginer (or pre-intermediate, if you will) like me could use, and hopefully avoid making mistakes in the future regarding my career As a programmer, I see technology, programs, and games that are so impressive, I don't know how I could ever surmount to something like that. I mean, I can barely use something as easy as XNA. Or does it just feel like that when you're a begginer, and later in life you'll be laughing at how "hard" you thought it was I just want some advice from a proffesional programmer, and I wanna kno ...Show All

• SQL Server Web Service Access

  Hi there, I have a problem accessing web service using Web service Task. I set up the task and can see methods available, but the result of execution is only that: < Result > The result is null. Either the result is null or the Web method returns void. </ Result > I can connect and get data using C# application. The difference is that I use a token in connection there. What should I do with Web Service Task to fix it Thanks in advance. Thank you, very much! I created my own component and use it in Script task. That works very well. Unfortunately WebService component isn’t capable to manage a call to web service with built in security. Thank you again, ...Show All