merivel's Q&A profile
.NET Development the performance of DataTable.Merge() in ADO.NET 2.0
Dear Sirs, I have see ideas at http://msdn.microsoft.com/msdnmag/issues/05/11/DataPoints/default.aspx and I have a question about the performance of DataTable.Merge(). It seems in ADO.NET 2.0 this method executes with increasing time when DataTable has more data rows, while merging about 10 rows each time. The table I used as follow, DataSet ds=new DataSet(); DataRow dr; ds.Tables.Add("BigTable"); ds.Tables[0].Columns.Add("ID", Typ ...Show All
SQL Server Print hardcopy of table structure
I've just started working with SQL Server Express, and would like to print out a report listing the properties (Ie. field names, data ttypes, length, field description, etc.) of each of the tables in my database. How do I do this The best way would be to use the INFORMATION_SCHEMA views and in this case the one that presents the columns definitions: SELECT * FROM INFORMATION_SCHEMA.COLUMNS HTH, jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All
SQL Server Transferring Records from a table to multiple files
Hi, I have a table - Student with 25 Million records. I want to transfer the records from the table to flat files. One flat file can contain only 1 Million record. So I need to generate 25 flat files with 1 Million in each file. Whats the best way to accomplish this task using SSIS. Any help would be appreciated. Thanks, loonysan I am trying to work out on the performance issues in this approach - In this approach we are taking the Top N records and moving them to the ouput file and the rest of the records to a temporary RAW file destination which will become the source for the next iteration. In this app ...Show All
.NET Development Exception: "The underlying connection was closed: The connection was closed unexpectedly." (sometimes)
I have a windows app connecting to a webservice. In some situation(s) (haven't narrowed it down enough), I get the following exception: The underlying connection was closed: The connection was closed unexpectedly. When this exception is thrown, it is calling a method of a web reference. Now the situation that we experience this is on a laptop in the field that is using a WWAN connection in at least one location. It works fine in the lab at the office. Anyone have any ideas what could be causing this If you are transfering large messages or the operation on the service side is taking very long you m ...Show All
.NET Development Deserialization Problem
hi I am communicating with asp.net page by my application at client side... client send data to asp.net page........ at client end i serializes the data to the stream and on server data is recieved and i stored that in a file... but when i try to deserialize data from stream directly or from filestream ..error comes to client application " Internal Server Error (500)............" i have searched a lot but did not find a single example of such type.. all examples are of simple serialization and deserialization........I have studied a lot on the web that assemblies on client and server side should be sa ...Show All
Windows Forms Drawing a textbox/combo
is there a way to override drawing a textbox or combo i have a MyTextBox control that inherits from textbox, i want it to draw normally if a boolean normal is set to true, or draw as a button/rectangle/frame (or sometrhing else) if the boolean normal is false. I tried overriding paint and paintbackground, not calling the base onpaint etc.. to no avail. ...Show All
Windows Forms floating Toolbar (ie IDE)
Hello everybody! Has anybody some experience with floating toolbars Is there a way to create toolbars like the ones that the IDE uses I wrote a custom control that simulates the same behavior, but it doesn't look as good as the "real" thing (and has still some minor bugs too). Any suggestions TIA Another toolbar control I just stumbled upon i ...Show All
Visual Studio Team System Can not Connect to TFS
I've been staring at this and I've narrowed it down to a machine-level issue...but I can't figure out what that issue is. When I try to connect to TFS, I get the following error: TF31002 - Unable to connect to team foundation server This is pretty much a generic message. Strange thing is that everyone else on my team can connect. Also, I can connect if I log onto one of their machines, so I know that the security is configured correctly on the server side. From my machine, I can browse to http://servername:8080/services/v1.0/registration.asmx without a problem. But I can't add the server in my Add/Remove Team Found ...Show All
Software Development for Windows Vista Download of incredimail script.
No matter what is done to change permissions nothing happens. You can't even install apps like Incredimail as you aren't allowed access to system32 and no changes of permissions anywhere allows access. Without access the installer can't see the mfc.dll and so can't install. TTFN. Once again the statements spawn their own questions. I guess this concept is lost on you. For instance. When I state simply "You can't even install apps like Incredimail as you aren't allowed access to system32 and no changes of permissions anywhere allows access. " Would you not be able to deduce your own question. For example: Why is the system not allowing ...Show All
Windows Forms How to make it so an app installs for ALL users, not just the current one?
I noticed when I create a setup.exe and install it, the app goes into \Documents and Settings\myUsername\... etc. How can I make it go into \Documents and Settings\All Users\ And have the shortcut available for all users as well, on a global level BUT still have the application settings on a per-user basis. This version of ClickOnce does not support control of All Users vs. Current User, you can only go to the current user. It's something that's being considered for future versions, but we wanted to get the Current User model right with this release. ...Show All
SQL Server SQL Express Advanced commandline install
I'm trying to install SQL Express Advanced Services from the commandline, but cannot get Management tools to install. Does anyone know the correct commandline to get this to work thanks, Daren Can you supply us with your command line so we can help troubleshoot My guess is that you are missing it from the ADDLOCAL tag. Thanks, Sam Lester (MSFT) ...Show All
Software Development for Windows Vista MPEG-2 Demultiplexer under XP 64bit
Hi All, Does anyone know is there any difference between the mpeg2 demux under 32bit windows and the one under 64 bit xp Since my BDA TV-watch app could work normally under 32 bit windows, somehow it fails on 64bit xp. Under xp-64, the TV video will lag seriously and I'm sure it's not due to the video decoder (because I record the stream directly from demux's output pin, and play the recorded file using mplayer, it still lag, just the same as live preview.). So I wonder is there any difference in using the demux In my app, after tune to a channel, I will map audio and video pid on the a/v output pins of demux. But I found this may be th ...Show All
Visual C++ How to Resize DialogBox in VC++ with Code?
Hi! I want to resize Dialogbox. Should I use from WM_SIZE function How Please Help me. thank. Hey! Take it to match.com. ...Show All
SQL Server creating a trace definition file (TDF) via code
Is there any way (either TSQL/SMO) to create a new TDF file, I'm using the traceserver InitializeAsReader sub, so need to pass it a reference to a TDF file, and I'd like to control what it traces via the TDF rather than parsing the TextData of the output. Cathal There is a Trace API that ships with SMO (see the Microsoft.SqlServer.Management.Trace namespace). See the TraceServer.InitializeAsReader() method. You can specify a predefine trace template as the second parameter and then start the trace with this template. ...Show All
Visual Studio Team System How can I access from VB6 to Team Server?
I have a lot of code developed in Visual Basic 6.0. For me is very dificult try to migrate all code to Visual Basic .NET 2003. I want to begin to use the visual team server, but my question is , how can I access from VB6 to the source code I uploaded to visual studio team server . In VB6 I don't expect to use any of the improvement in the new source control server. I don't want shelve, policy or other, the only thing I want is to be able to check-in and check-out code from visual basic 6.0. Thanks you very much. We've received a lot of customer feedback on this issue. We're actually workin ...Show All
