Bernie44601's Q&A profile

• SQL Server Improving conversion performance

  I have a varchar(max) field that is on its way to a Term Lookup task, so it requires conversion to DT_NTEXT before it gets there. The conversion is taking a really, really, really long time. In my current example I have about 400 rows. Granted the length of the varchar(max) if I 'select max(len(myColumn))' is approximately 14,000,000 so I understand that I'm moving a lot of data. But I'm on a x64 machine with 4 dual core processors and watching Task Manager I can see that I'm only using 1 core out of 8. Anything I'm missing that can speed this up Thanks, Frank Thanks for the pointer to the excution thread information. It was taking upwards of 20 minutes to convert the sampling of rows I had. I w ...Show All

• SQL Server Source code for Windows Forms Viewers?

  Any plans to make the source code of the Windows Forms data mining viewer controls publicly available ...Show All

• SQL Server Windows Authentication - Different Domain

  Hi: I am trying to figure out if there is a way to connect via SQL Server Management Studio to a server sitting on a separate domain. So here is the situation. there is Server B which sits in a domain called DomainB. If I am in DomainA, I could typically remote into that server utilizing an IP address in DomainB, and even transfer files to that server. But how do I connect via SQL Server Management Studio(basically login as a different domain user) to Server B in DomainB from DomainA. Basically when I choose Windows Authentication from the dropdown list in SQL Server Management Studio, it grays out the username field, which is where I could type something like this domainB\usernameondomainB, similar to how you would connect to a share o ...Show All

• Visual Studio Tools for Office VSTO deployment close to solution

  Hi all, I'm backing down to make sure I find a way to deliver to my customer the next few days: I have developed an Excel template with some .NET code behind using VSTO 2005. Not the SE, the first version. My solution uses another .NET assembly (helper.dll) besides the code assembly data.dll "behind" the document (data.xlt). I added a setup project to the solution. Which isn't enough of course. I created to separate install classes, one to install a policy code group thats gives Full trust to data.dll and one to bind the data.dll path to the data.xlt document (via ServerDocument). I added the custom Action to Install the CustomSetup.dll with these installer classes. Now to my questions: Are there any walkthroughs to t ...Show All

• Visual C# StructLayout, Marshalling

  I send and receive packetized data over a serial port connection. The data is strictly defined, so the memory layout of the interface defintion has to be implemeted in C#. The type of packets I am sending/receiving look something like this: // Temperature Packet Id=5 int PacketId; int PacketLen; int32 CurrentTemp; int16 CurrentPressure; Bool IsHeaterOn; Bool IsHeaterEnabled; byte LastErrorLimit; // UserPacket Packet Id=12 int PacketId; int PacketLen; char [64] CurrentUserName; int32 LastLoginTime; So I will be setting/reading bits, bytes, words and strings in multiple packets. I have discovered the StructLayout attribute and think this could be the best way to implement this ( ! ). I am using C# and want to use manage ...Show All

• Internet Explorer Development Problem printing page with Iframe..

  Can anybody help me out... Im printing a page with an Iframe... The scenario is this.... The content of the Iframe is to long to print... I expected that when I print the page it will print with multiple page but it printed only one page worth..Meaning the printing did'nt continue to the next page.. Please help... ...Show All

• Visual Basic Excel Application in VB

  Kindly help me how to open Excel application through VB Code Or if you want to open excel with a specific spreadsheet System.Diagnostics.Process.Start("Test.xls") will open the file with the associated application - in this case for an xls file it would be Excel. If Excel is installed on the client machine and has the appropriate file association (which it should) ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Let's go 3d engine

  sorry about my typos i am word blind , but the math thing is in place Hello i like to share some info width you mabye you have seen crytek 2 engine and my is how do we make a aaa 3d engine here is a link to a paper about the crytek 2 engine http://ati.amd.com/developer/siggraph06/Wenzel-Real-time_Atmospheric_Effects_in_Games.pdf well the 3d evolution game engine(my engine)  is based on the paper and alot of other info found on the net and i will soon realease the full source code the engine + a 3d fps game here is a video shot (big file) of the engine it runs in xna beta 1 so it a bit old video http://www.3devolution.net/Portals/0/Gameshot.wmv more video is comming before realease date so you can pla ...Show All

• Visual Studio Working folder changes after moving the code to other location

  Trying to explain the problem by an example: 1. I set working folder folder as C:\Sourcecode 2. Now, idea is to have a copy of the source code as backup in different folder. So I copy the code from C:\Sourcecode to C:\Sourcecode_BAK 3. Now I go to C:\Sourcecode_BAK and open the solution. Unbind the solution from VSS and try to edit some code. 4. Now open VSS, you will find that working folder changes from C:\Sourcecode to C:\Sourcecode_BAK. As this is not consistent, you might not be able to reproduce. so try 2-3 times. I want to prevent this. though there are manual ways. I mean once copy is done remove all vss related files from the root folder and subfolders. Remove readonly attribute on rootfolder. Remove vss related entry from .sln ...Show All

• Windows Forms PropertyGrid Commands/Verbs drawing problem

  I'm using the PropertyGrid in my application to allow users to change settings. I used the code at this link as the basis for adding Command support to my PropertyBag class so that the user can click them for actions. http://blogs.crankygoblin.com/blogs/geoff.appleby/archive/2005/06/16/64688.aspx That code is working correctly, however the window where the commands (or verbs) are being drawn grows vertically with each new command. So if I have only 1 command it draws correctly, but if I have 2 commands, it makes space for two rows of commands even though the commands all fit on one line. Using Reflector, I looked into the .NET Framework code and found the HotCommands class. It implements the GetOptimalHeight method like this: ...Show All

• Windows Forms Why is DataGridView so slow?

  I created a databound DataGrid, and then researched DataGridView to find it would fit my needs better. I have a DataGridViewCheckBoxColumn as my first column in my DataGridView then set its datasource to a DataSet. Sometimes the DataSet may contain a table with over 1000 rows. The user has a button that will select all checkboxes in the DataGridView. It takes about 5 minutes for my foreach loop to complete this task with the DataGridView. With the DataGrid, it was milli-seconds. What is going on Any suggestions Here is some of the code. Thanks in Advance, ryan //my DataGridViewCheckBoxColumn truevalue = 1 foreach ( DataGridViewRow dgr in dtgPolicies.Rows) { DataGridViewCell dgc = ( DataGridViewCell )dgr.C ...Show All

• Visual Studio Team System Driving a test method with data from an Xml file

  I know that you can supply a DataSource for a test method which will allow use of a database source, or a text file via ODBC. Can anyone tell me if there's an "easy" way to drive a test method using an Xml file as a source for test data So far, the only thing I can come up with is implementing my own DbProviderFactory for Xml. Is there another way Thanks. An example of how to do this can be found in this post: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=79672&SiteID=1 Dennis ...Show All

• Visual Studio 2008 (Pre-release) How to exit a WPF application

  Is there a way to force a WPF application to exit,.. something like application.Exit() in windows forms If not, how can I, for example force an application to exit on a button click Thanks in advance, Marko Vuksanovic. When you call Window.ShowDialog(), WPF will actually pump a new nested message loop, the problem is that during the initialization of Window1, there is some layout taking place, the problem here is that WPF will disable nested message loop when doing layout, that's why your application crashes when you call popUp.ShowDialog(), actually Nick Krammer has a blog article dedicated to nested message loop. Nested message loops are evil (if you're a platform) Sheva ...Show All

• Visual C# Object Test bench is not visibile

  Hi, I am using Visual studi team system RTM version(8.0.050727.42). I am working with a e-commerce project. I have written some classes in Business layer. I need to check it by creating objects of these classes before creating aspx forms and checking it from there. I heard that object test bench is useful. But I cant see any sign of this facility.That is, I cant see 'create Instance' option when I right-click on classes from class view or class designer. can anybody explain why it is like this Thanks in advance... akajal You must install the J# components when installing visual studio in order to get the OTB to work. OTB was written by the J# guys and thus requires the J# co ...Show All

• .NET Development Why is Console in the backgroud?

  When I create an empty project with Express Visual C++ and make a windows form on the fly, I get the console in the background with the title C:\Windows\System32\cmd.exe. Why is that This feature did not exist in 2003 VC++.Net. Is it a part of Express Edition of VC++.Net What can I do not to display the console in the background Regards Modeller. As a matter of fact, I have 8 projects in the same solution and all of them are displaying Console in the background. Just to make sure that I was doing right, I created a new solution and started a new empty project with CLR->Emptyproject. It also gave a console in the background. I have been using VC++ since 2003 this is the first time that I have e ...Show All