Terrence Chan's Q&A profile
SQL Server Bulk Insert performance
I have a situation where I need to do multiple inserts into the sql mobile db at one time. I am wondering what would be the most efficient method to do this. Right now I am just doing many inserts, but the performance is lacking. I tried to wrap all the inserts into 1 sql command and process it like that, but it does not seem to want to execute. Any help would be appreciated. Jack, Instead of using the table adapter, try a parameterized insert. Here is the "pseudo code" to do this: SqlCeCommand cmd = null SqlCeParameter param = null try cmd = _mysqlceconnection.CreateCommand() cmd.CommandText = "INSERT INTO tablename VALUES (@Param1, @Param2, @Param3)" ...Show All
.NET Development developing webservice on Dev server
Please let me know if this is correct. I would like to have a Web server installed with visual studio 2005. Develop web services in it. Then from the workstation where I develop apps, reference the webservices on the web server, as opposed to what I do now (Developing webservices in the same solution with the other projects). If the above is possible, then how do I referene the webservices on a webserver on the same network Is it by add webreference and enter the http address of the services in the web server Thanks Using .net 2.0 It seems the setting is set to dynamic by default. So basically, from the client project, I have to enter the http address to the webserver via Add Webreference Should there be a ...Show All
Visual Studio Express Editions how to make a rich textbox print
A friend and i mades text editors and we wanted to know how to make the docyument print thanks ahead Josef Stalin C# is extremely similar to VB: when asking a question on how to do something other than how to create a for/next loop, or syntax related questions, then you will use the same commands in C# as you would in VB. For example, to set the cell of a DataGridView in C# is exactly the same as in VB. Some samples are only in C# or visa versa. In addition, it pays (sometimes literally) to be conversant in both. Remember, also, that the question/problem is important only to the poster and not anyone else - to get the results needed you have to be versatile in accepting what answers you get. ...Show All
Visual Studio Error installing SP1 for VS2005
I've downloaded the SP1, tried to install it. The installation hung up, and the error I've found in the log file is - Item ID: VS80sp1-KB926601-X86-ENU.msp to "<path>" ERROR [16389] ERROR [16389] - Extracting package item to file ERROR [16389] ERROR [16389] When execution started, the publisher was unidentifed, rather than Microsoft. Tried to download the file half a dozen times, clearing the cache, rebooting the computer, and to no avail. Using XP SP2 English, and downloaded the English SP1 for VS2005. When I got the error, the installation processs froze, or at least so it seemed. Eventually I just got a new hard disk, made a 12GB partition for sy ...Show All
Visual Basic vb6 to vb.net
hi everybody, Is there any easiest way to do conversion If any of you have good experience in Converting the applications from vb6 to vb.net, Please give me your suggestions. Regards A.K Open the VB6 project in Visual Studio - the conversion wizard go through the upgrade process. Note that this is not a light undertaking except for the most trivial of applications - you will still need to go through the code almost line by line to ensure it still does what you want. The converter is more of an 'interpreter' than anything: it won't take advantage of the more powerful ways of doing things in .NET. Expect to have at least a dozen (or several hundred) warnings and errors that you may ne ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Directx symbol files
Hi, I've seen that symbol files were available to dowload on microsoft website. I've tried to do something with it but i didn't manage. Could someone explain me what this files are used for. I thought it was unusable without source files, isn't it Also, could someone tell me (or give me a link) how to setup VC 2005 to use this files Regards Guillaume With Google (Feeling Lucky): http://support.microsoft.com/kb/291585/ and: http://www.codeguru.com/cpp/v-s/devstudio_macros/debugging/article.php/c11975/ I hope this helps ...Show All
Visual Studio Team System Code Analysis has dissapear from automatic build in release mode
When I have changed the compilation mode from debug to release, Code analysis don't apply to automatic build process. it's correct or musn't happen this. Thank you. Regards. Sara is correct, the Enable Code Analysis option is scoped per configuration, so you will need to turn it on for every configuration you want to run it for. By default the pdbs should be generated in release mode, and although we don't require them for analysis, we do give better results if they are present. ...Show All
.NET Development Write data on webserver.
Hi, I wants to create a xml file in the webservices virtual directory from C# desktop application. can any one help me out You need to give the server permission to write to the directory, you can do this by right clicking on the folder, select "Sharing and Security", then select the "Security" tab and clock the "Add..." button type in the account name "ASPNET" and click ok. Then check the "Write" checkbox in the Allow column. ...Show All
Windows Forms IE .net toolbar (C# Zolnikov's Toolband and .net kbbar) on IE 7: toolbar unmovable!
hi, I'm developping a C# IE toolbar, which work well with IE 6, but I noticed a problem with IE 7 beta 2: the toolbar cannot be moved! It's acting as if the "lock the toolbars" were checked. The problem occurs with both the .net kbbar ( http://support.microsoft.com/default.aspx scid=kb;en-us;821793 ) and Pavel Zolnikov's toolband sample ( http://www.codeproject.com/csharp/dotnetbandobjects.asp ). But with ATL/MFC or WTL toolbar samples, there is no problem, as there's none for toolbars like the Google one. Do you have any idea how to make such a toolbar act as in IE 6 Thank you very much for your help! Thibaud OK, it does work. Thanks for the code. However, when I add a button to the to ...Show All
Visual Studio Tools for Office VSTO 2005 SE
I have installed VSTO 2005 on top of VSTO. From the main web page, I should now have, among many other things " Expanded application-level add-in support for these Office 2003 Standard and Professional applications: Word, Excel, Outlook, PowerPoint and Visio." Where can I find out how the application level add-in support has been expanded In other words, what can I do now what I couldn't do before Many thanks. Michel There is actually plenty of information available online on MSDN. You can start with the main VSTO 2005 SE portal at: http://msdn2.microsoft.com/en-us/office/aa905543.aspx Hope this helps. ...Show All
SQL Server sql server lockup after strange error in log, help please.
Can anyone help me solve why my server is locking up. We're running sql server 2005 ent on a 2 cpu dual core server. With 3gig. Once each the last couple weeks, the machine has hung and the only thing I can find that's suspicious is on the sql server log. It's below. After the excerpt is about 50 more different memory errors. As far as I know there's no ssl configured for log in, it mostly uses private lan cards for security between it and the web/application server. 05/31/2006 14:39:48,spid2s,Unknown,MEMORYCLERK_SQLQUERYEXEC (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committe ...Show All
Connected Services Framework OHSBE | Multiple Order Management System
We have a system, where we have to integrate with multiple order management systems. Have the following questions 1. In such a scenario, where would the product service mappinng service be implemented How would OHSBE service know which PSM service needs to be called 2. Also, if all the OMS calls the OHSBE service, it would be a point-to-point interaction. Tomorrow if a new OMS is introduced, it could mean changes. Do you recommed using BTS as layer between OMS and OHSBE Hello Sachin, OHSBE can interact with only one PSM service. Hence you should implement only one PSM. OHSBE by itself will not know where the PSM service will be. You need to use the OHSBE Configuration tool to set the PSM service URL. OHSBE ...Show All
Software Development for Windows Vista Expired timers are processed very slowly
We have a process where thousands of workflows are created within 30 min time. Most of these processes are awakened by a delay some hours later, invoke a web service and then end. This all works perfectly, except that the workflows that expired are processed sequentially, one after the other, making the process take several hours instead of the 30 min it would take if several workflows were processed in parallel, we tested it by removing the delay. Also, because of the sequential processing, the workflows that are run last are run much later that the expiry time. This is using ManualWorkflowSchedulerService and useActiveTimers=true. Is there a way to force ManualWorkflowSchedulerService to process several expired workflows in parallel Tha ...Show All
Smart Device Development writing GUI for PPC with changing display aspect ratio
Hello, I need to write an application for a WM5.0 PPC. The device I have has a sliding screen. When that screen is used the aspect ratio of the display is changed from portrait to landscape. Is there any way I can write my GUI in such a way that will automatically rearange the components to fit the different display ratios Is there any layout manager Thanks, Zohar. Hi Zonar You can use the new Docking and Achnoring properties available with .NET CF 2.0. If this is not powerfull enough, use the Orientation Aware Control available with the Mobile Client Software Factory. Details can be found here: http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnpag2/html/mcsflp.asp Regards,. ...Show All
.NET Development deploy and manifest file?
I publish my app to a ftp server on that ftp server i found two files which are windowsApplication9.exe.deploy & WindowsApplication9.exe.manifest My problem is how to use these two files.. Deploy and manifest files are for what purpose In fact, on the server i also found a few other files and one of them is publish.html and the add is http://www.pp.somee.com/test/publish.htm But on the page, i fail to execute or run the app i create for testing purpose only. Besides, how is it possible to hav the relevant components like the .net framework install automatically on a user computer who lack of it. ...Show All