redshock's Q&A profile

• SQL Server R

  How do i replace that character in a derived column Some rows have that character in one or more columns. If i just write this column == "" Unknown : column where the character is inside "" (can't write it here) the task will just succes without ever doing anything. The output says something like "the dataflow task had no tasks.....", which seems like a bug. hmm and if it's not a unicode character Try putting this in a derived comlumn REPLACE(TRIM(TXT)," ","") the task will then complete with this in the output. Warning: 0x80047034 at Data Flow Task, DTS.Pipeline: The DataFlow task has no components. Add components or remove the task. ...Show All

• Visual C# Should I use Dispose in this situation

  hello, i'm initiating an object inside a method: private void Example () { MyClass ins = new MyClass(...); ins.AMethod(); ins.Dispose(); } i'm wondering if the last line: ins.Dispose(); is necessary Or C# does it automaticlly ... i mean disposing the object as soon as the method is finish. please advise Hi, It is very advisable to call an objects Dispose method. If the object is implementing IDisposable, or has a dispose method available then you'll need to call it. In your example, after the method finishes executing your object would be removed by the garbage collector. But what if that object uses a umananged resources That is when memory leaks appear. So as a precaution, alwa ...Show All

• Visual Studio embedding relationship

  Hi, I do not know if I overlook the obvoius, but is it possible to embed a concept into more than one concepts. An example. I have a ComponentModel that embeds Component and CompositeComponent. Now I want to be able to add a Component to a ComponentModel and to a CompositeComponent in my custom designer, respectively Since a concept can only have one parent element path, I do not know how to implement such a scenario. I have to say that the CompositeComponent is represented by a kind of ContainerShape (the one from the customization documents), thus accepts Components, so I can display Components on top of CompositeComponents. Thanks Alexander How can you change the ParentShape This property is readonly. ...Show All

• SharePoint Products and Technologies VPN Windows server 2003 Certification Authority

  I need to make a remote access for a Windows XP client using a VPN to my windows 2003 server R2 based domain. The thing is I want to use certificates, and I need help for this configuration. How shall I setup the server so that it promts the user with a certification message when trying to log in the domain You might want to post this under another forum topic - like networking or security - doesn't seem to much related directly to sharepoint development. ...Show All

• Visual Studio Team System Known issues? Rename, checkout not working?

  Are there any known issues where a file does not get checked out when using silent checkout User claimed they edited file but was not showing in pending checkins. Are there any known issues of renaming files in a project not working We have ocassional user reports of this, but we have not been able to get a good enough description to reproduce. Thanks The root cause of the problem is that the code that validates the rename is permissible (before performing the rename on disk and in SCC) has a bug where a file in a pending add state is not recognized as controlled. This causes the code to bypass the validation check that would have realized the rename would collide with the pending delete. ...Show All

• Visual Studio Team System link work-items with other work-items , not with linkscontrol

  hi, i want to make a drop-down were i can choose the name of some specific work-items. for examble in the first drop-down i want to choose instances of work-item A. in the second drop down i want to choose instances of the work-item B. is this possible i want to do this because the links-control is not enough for me, because i don`t want that if a work-item is linked with three different work-items, all are shown in the links-control tab. If you want to query for items of specific type, you do not need to dig into the workitemtype xml. You can get those items from workitemtracking object model. There are bunch of samples in VSSDK and documentation. Once you download sdk from http://msdn.microsoft.com/vstu ...Show All

• Visual Basic I've run this before without a problem, but now I'm getting a warning!

  Okay, I've run this before without a problem, but now I'm getting a warning stating "InvalidArgument=Value of '1' is not valid for 'index'. Parameter name: index" . Why would it begin giving me this error now after running it in debug several times without a problem before Anyone, please help. cool, thanks. this is what I added to my code and it works fine now. Thanks for spotting that.... Private Sub DeleteButton_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles DeleteButton.Click 'Check which item has been selected' Dim Count As Integer = Me .ListView1.Items.Count Dim AddFromZero As Integer = 0 While AddFromZero < Count If ListView1.Items( ...Show All

• Software Development for Windows Vista Communication with external applications

  Hello, I've been trying the hands-on labs and now I'm developing a simple workflow myself, but I don't really know how to communicate between an external application and the local workflow. I know that lab05 deals with a similar topic but I've found that the communication was only between a LOCAL application and the workflow but not with an external application. Now I'm trying to follow the expense reporting application in lab01 (resources folder) and I try to see how it communicates with the workflow. I've seen it uses .NET Remoting to create an instance of the remote class, but I don't get to understand well what it does because the same project has together the remoteservices class and the localservices class. Please can someon ...Show All

• Visual Studio Express Editions Tackling an issue

  Hi all, I'll try to describe this as best I can. If it gets a little confusing, let me know and I'll try to rephrase everything I've said! For the past few weeks I've been trying to get my head around VB2005EE. After reading a few books and tutorials I feel that I'm almost ready to go ahead and build my first "real" program to distribute. The program I have in mind should be nothing complicated, but I'm a little confused on how to build the key feature. Without giving too much away, my idea is to build a large database on every ride, roller coaster and theme park in the world. Each entry will feature statistical information on the particular attraction, along with media (video/pictures), location etc. - this will mean I'll have ...Show All

• SQL Server Object Explorer - Group By Schema?

  Hello all, I'm new to SQL Server Management Studio and was wondering if anyone knew of a way to group by schema's under the Tables node in the Object Explorer. I know you can use a filter to show just the schema you want, but it would be nice if there was a way to have the schema's themselves show as a node which could be expanded. If anyone knows of a way or a plug-in, it would be greatly appreciated. I'm running SQL Server 2005 Enterprise (64-bit) with SP1. Cheers, Corey This is not possible with SQL Server 2005 Management Studio. If you'd like us to consider this for a future release, please file this as a suggestion on Microsoft Connect. http://connect.microsoft.com/SQLServer/Feedback/ . Paul A. M ...Show All

• Visual Studio 2008 (Pre-release) Multiple Endpoints and Discovery/WSDL

  I have two endpoints being exposed by a single IIS hosted service. One endpoint is tied to one service using the base address of http://server/serviceapp/service.svc . The second endpoint is tied to the following URI: http://server/serviceapp/service.svc /otherendpoint When I browse to base URI, I get canned WSDL page, but if I browse to the /otherendpoint I get the following: - < s:Envelope xmlns:s =" http://schemas.xmlsoap.org/soap/envelope/ " > - < s:Body > - < s:Fault > < faultcode xmlns:a =" http://schemas.microsoft.com/ws/2005/05/addressing/none " > a:ActionNotSupported </ faultcode > < ...Show All

• Visual Studio Formatting Windows ReportViewier animated "SHOWPROGRESS" Screen

  Hi All, I am creating a report using WinForms.ReportViewer Control. The report is being generated and being displayed very nicely. However, my requirement is that, before the report is being generated, we get a Flash screen which shows the message "Report is being generated" alongwith an animation of a swirl with a green progress bar rotating. I wish to change this color from green to blue. Also, I need to change the text "Report is being generated ". I would be very thankful, if anybody can help me out for this issue. Please help Thanking You in advance Regards Pratik It is possible to change the text by implementing IReportViewerMessages and passing your implement ...Show All

• Software Development for Windows Vista Communication with the underlying transaction manager has failed

  Does anyone has any idea I have to resolve this exception: Communication with the underlying transaction manager has failed InnerException "Error HRESULT E_FAIL has been returned from a call to a COM component. (System.Transactions) ------------------------------ Program Location: at System.Transactions.Oletx.IDtcProxyShimFactory.ReceiveTransaction(UInt32 propgationTokenSize, Byte[] propgationToken, IntPtr managedIdentifier, Guid& transactionIdentifier, OletxTransactionIsolationLevel& isolationLevel, ITransactionShim& transactionShim) at System.Transactions.TransactionInterop.GetOletxTransactionFromTransmitterPropigationToken(Byte[] propagationToken) " I've tried all the solutions from http: ...Show All

• Visual C# write data to file, data lost..

  FileStream file = new FileStream(@"C:\test.txt", FileMode.OpenOrCreate, FileAccess.Write); StreamWriter sw = new StreamWriter(file,true); string s = comport.ReadExisting(); sw.Write(s); sw.Flush(); sw.Close(); Q1: when I use StreamWriter sw = new StreamWriter(file); the program runs OK. however, when I add "true" as the 2nd argument to append data to the file, the following errors show: Error 1 The best overloaded method match for 'System.IO.StreamWriter.StreamWriter(System.IO.Stream, System.Text.Encoding)' has some invalid arguments Error 2 Argument '2': cannot convert from 'bool' to 'System.Text.Encoding' I do not know what's the problem... Q2: I read da ...Show All

• .NET Development How to accomplish using XML?

  I have a Xml file and the associated schema files. I am trying to convert the Xml to Csv format. The fields used to represent every row in the Csv can vary thereby some fields will be present in a certain row and may not be present in another row. I want to identify the all the fields present in the Xml file and use it as the columns list in the Csv. For every row in the csv, i will leave the non-applicable field as empty. So, how do i find the complete list of columns from a given xml TIA Sek Suppose you have the following XML document: < catalog >    < book id = " bk101 " >       < author > Gambardella, Matthew </ author & ...Show All