Shilpa_nad's Q&A profile

• SQL Server import hierarchical data

  hi folks, I have to import hierarchical text files like: 32;country;city;postalcode;street 21;name;firstname;salutation;title;age;nickname 21;name;firstname;salutation;title;age;nickname ... additionally I have to eleminate doubles. what is the best way for this problem I have set up a flatfilesource with two columns and a conditional split on the first column so now I have an output with [country;city;postalcode;street] and one with [name;firstname;salutation;title;age;nickname]. How do I split this in columns, put it in a dataset keeping the relations and remove doubles Iam looking forward for any helping idea. rgrds, matze 1. Use ...Show All

• SQL Server compare two text files

  Dear all, What software can compare two text files They are contains about 100k data generated from Visual Basic 6.0 program and MS SQL 2000. I have many files to compare daily. Please give me some suggestions. Thanks. Alex Hi Alex, I don't know if it is allowed to share free software here or not, howere you can serach google for compare text files free ...Show All

• Windows Forms DataGridView and Custom Collection

  I have a custom collection I'm binding to a DataGridView.  I've set up the columns in the designer to make them show in a partcular order.  It loads fine initially, but when I add a new item to the collection, the new row doesn't show up.  If I do dgvRFM.DataSource = Nothing dgvRFM.DataSource = _rfm   the row will show up, but the order of the columns I set up at design time is lost.  I'm assuming there's another way to go about making the datagridview refresh with its bound item, but I can't find it.  I've tried dgvrfm.update and all kinds of other methods.  What am I missing here ...Show All

• SQL Server Time Dimension - Attribute Hierarchy

  I have a Time dimension built from Dim_Time Table.Dim_Time table structure as follows : TimeId int]  IDENTITY ( 1 , 1 ) Hour          tinyint Minute       tinyint Second      tinyint TimeId      Hour            Minute           Seconds n              0..23           1..59 & ...Show All

• Software Development for Windows Vista Question about performance overhead

  Hi All: I am researching feasibility of using the Windows Workflow Foundation for an internal requisition and procurement workflow application (ASP.NET frontend). This system will have up to 300 concurrent users across the enterprise. If I am to implement WWF for this project, does this imply up to 300 workflow instances loaded in memory If so, what are some of the performance implication I need to keep in mind Any input would be greatly helpful, thanks. Hello, It is unlikely that the number of concurrent users of your application will correlate with the number of concurrent workflow instances. The maximum number of workflows ...Show All

• Visual Studio Express Editions Adding Stopwatch Class

  There's a new Stopwatch class added in Microsoft Net 2.0 that I want to try out. I don't know how to do this . I've tried to code it in the following example. At this point I get an error message in the Button_Click event handler that says Start is not a member of Stopwatch.Stopwatch. Imports System.Diagnostics Public Class Form1 Dim StopWatch1 As Stopwatch Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click StopWatch1.start() End Sub End Class Public Class Stopwatch End Class You will get a better answer if you ...Show All

• Visual C# C# COM question

  I have a dll that I use in VB 6. I create a variable called DB, I access the records in the DB like this DB(index).PutStringField("data") when I try that in c# I get an error is a 'property' but is used like a 'method' I have no idea what to do because I have not done any COM interfacing in C#. Is it a simple syntax problem or do I need a different version of the dll that I have always used ANY help is greatly appreciated. It’s a syntax problem. In C#, the indexer is surrounded by square brackets, not round ones. Bruce Johnson [C# MVP] http://www.objectsharp.com/bl ...Show All

• Visual Studio 2008 (Pre-release) Flashing taskpanes?

  Is it possible to make the avalon window's taskpane flashing like e.g. MSN Messenger Conversation windows do when a new message arrives   Thanks, Jan-Cornelius Molnar I'm not positive but I think what you're seeing is just the standard Windows "application that doesn't have focus is trying to grab focus" look -- their taskbar button flashes.  So if you're in Win32, call SetForegroundWindow, and in WPF, call Window.Activate().  If you're process doesn't have focus, you will flash. ...Show All

• Smart Device Development Memory Leak with Datasets!?

  I have noticed a memory leak in conjunction with datasets in compact framework. Now I've found another post in Common Language Runtime section  (http://forums.microsoft.com/msdn/ShowPost.aspx PostID=123316): in full framework seems to be a memory leak too. But the solution described there didn't work for me in compact framework. To test the suggestion I've made a small program. But I get an error after the fourth call (the german message is: "Fehler bei systemeigener Ausnahme" Ausnahmecode: 0xc0000005). Below is a little abstract of code. Public Class CountedDataSet     Inherits DataSet  &n ...Show All

• Visual Basic Mask in datagrid

  How can I make a masktextbox in datagridview cell !!!!!!!!!1 See the sample at http://msdn2.microsoft.com/en-us/library/ms180996.aspx Jim Wooley http://devauthority.com/blogs/jwooley/default.aspx ...Show All

• .NET Development Bug in Silent License Acquisition for server side playlist, any solution?

  playlist1:(test1.wsx) < wsx version="1.0" > <smil>   <media src="C:\Clip\no_drm.wmv" />   <media src="C:\Clip\with_drm_vid1.wmv" />   <media src="C:\Clip\with_drm_vid2.wmv" /> </smil> playlist2:(test2.wsx) < wsx version="1.0" > <smil>   <media src="C:\Clip\with_drm_vid1.wmv" />   <media src="C:\Clip\with_drm_vid2.wmv" />   <media src="C:\Clip\with_drm_vid3.wmv" /> </smil> with this playlist the second and third video does'nt play. It seems that the Silent License Acquisition does not work in server side playlist. Any workaround to m ...Show All

• Visual Studio Crystal Reports 10 full version and Visual Studio .NET 2005 Standard

  I have only the standard version of VS 2005 but do have the full CR 10 Developer on another machine. I know VS 2005 .NET Professional has  a 10.2 version of Crystal  bundled but I want to take the full CR 10 from the other machine and load it on my VS 2005 standard machine. Before I go through the uninstall/install routine will CR 10 work on VS 2005 .NET standard   If partial support is provided, what will I miss   The Crystal sites only mention CR 11 which I do  not have yet and do not show the compatibility of other versions. Thanks for any replies Ben Sorry ab ...Show All

• SQL Server Query Returning to many results

  SELECT tblWatchInstance.RepairNumber, tblWatches.Serial_Number, tblWatches.OwnerFName, tblWatches.OwnerLName, tblWatchColors.Description, tblRepairCodes.Name, tblWatchTypes.Description FROM tblWatchInstance INNER JOIN tblWatches ON tblWatchInstance.Watch_Key = tblWatches.WATCH_KEY INNER JOIN tblWatchColors ON tblWatches.COLOR_KEY = tblWatchColors.COLOR_KEY INNER JOIN tblWatchBrands ON tblWatches.BRAND_KEY = tblWatchBrands.BRAND_KEY INNER JOIN tblWatchTypes ON tblWatches.WATCHTYPE_KEY = tblWatchTypes.WatchType_KEY CROSS JOIN tblWatchStyleDial CROSS JOIN tblRepairCodes WHERE tblWatchInstance.WorkStatusID <= '10'" ...Show All

• Visual Basic Click Once Deployment

  After seeing Jamie Cool's video on Click Once deployment, I am now experimenting with it - on VS2005 Beta 1 (Beta 2 is on order!) It looks really neat.... However, how do you put other files such as a text file and help file into the deployed application folder.  With other forms of deployment you can simply add them to the folder.  I can't seem to find something similar through the Click Once method. I have tried adding the help file as a resource.  Whilst it appears in the resource folder on the solution explorer it does not appear in the list of files that I can choose to deploy with my project.  I am sure there must b ...Show All

• Visual Studio MSBuild is not copying the assembly to the output directory.

  For some reason, when I compile projects using MSBuild, it occassionally fails to copy an assembly to the output directory. No errors occur, the assembly is built correctly to the obj directory, and compiling the project a second time using MSBuild seems to work fine. The MSBuild output seems to indicate that the file was copied without any problems, however, the file is not in the output directory. I had the same problems with using VS from the command line (not surprising of course). Any suggestions We have over 200 projects. Having to compile multiple times to get a project to compile correctly is not a realistic alterna ...Show All