SWB108's Q&A profile
SQL Server Upgrading to Sept CTP - any BKM?
I have already installed June CTP. Have created a new database also, for testing. My packages and projects are in a separate drive and hence I do not see any danger to those. But when I want to install the new CTP, I do not want to loose my database. How should I go ahead Do I use Build Cleanup Wizard Any other BKMs anybody can share Yes you use the Build Cleanup Wizard. This saves your system databases. There is a readme that explains how to select these when you install the sept ctp ...Show All
Visual C# how to let it work faster?
I have the following code which download the data from a website and find the match word........but the problem is the downloaded data too big, it take a lot time to do the matching, is there anyway to make it work faster Need help !! private void button1_Click(object sender, System.EventArgs e) { string str_variable=textBox1.Text; string HTMLText; string url =" http://bursa.n2nconnect.com/BursaStockSearchAll.htm "; WebClient client=new WebClient(); byte[] data=client.DownloadData(url); HTMLText= System.Text.ASCIIEncoding.ASCII.GetString(data); HTMLText = System.Text.RegularExpressions.Regex.Replace(HTMLText, & ...Show All
Visual C# Word object and its Enumerations
I need to store various printer settings into the database (this would be done by the user thru “Maintain Printers” screen). 1. In what format I’ve to store the printer information (paper source, papersize …) 2. Then how do I apply the stored values to word object. (It’ll accept only its enumerations) You can find the names and values of the members of any Word enumeration using the Object Browser and Immediate Window in the Word VBA IDE. Here are the members of the Word 2003 WdPaperTray enumeration and their values, copie ...Show All
SQL Server oledb source issues with parameters
Hi, I been having issues trying to use the OLE DB Source in the DataFlowTask. If I use the SQL Command to build a SQL Statement, i.e. "select * from tablea a join tableb b on a.column1 = b.column1 where column2 = ", I can't get the query to parse and it won't allow me to set a value to the parameter. It seems to be a bug as the only way I can see to get around it is to use a variable to place my sql statement into and use the "SQLCommand with Variable" option in the OLEDB Source. This seems pretty clunky to me as I should be able to just put my select statement in the SQL Command window, right Is this going to b ...Show All
Windows Forms Problems deleting databound info
Hi All, I have a form with lots of related databound info on it. If a user loads up the form it starts creating a new 'booking' and adds new 'booking dates'. If they then decide to close the form without doing anything I need to delete all the info created. My form is bound to lists of buisness entities and I need to delete them all and remove them from the lists. Problem is I get: "DataBinding could not find a row in the list that is suitable for all bindings" I assume I have left something behind but I dont know what or how to find out. Any ideas Danny No. The project this occured in is currently on hold. It might be resolv ...Show All
Windows Forms Disable sizing/movement in the designer?
I have derived a new control from Panel and now want to customize the design time support. My designer derives from the PanelDesigner and works as expected except for one feature. When you select a regular Panel it gives you the small box on the top left of the control allowing you to move the Panel around. I want to prevent the user from moving or sizing my panel derived class. Any ideas how to disable this sizing/movement ability in the designer Phil Wright http://www.componentfactory.com Free UI library for .NET2 Add this code to your designer class. This would keep it from being moved or resize ...Show All
.NET Development bug in Int32.Parse
In Visual Studio 2005, the following throws a FormatException and it definitely shouldn't. The same code works fine in Visual Studio 2003. This is the version that I am seeing the problem, running on XP: Microsoft Visual Studio 2005 Version 8.0.50727.42 (RTM.050727-4200) Microsoft .NET Framework Version 2.0.50727 Installed Edition: Professional int x = 0; x = Int32.Parse("0") // throws FormatException x = Int32.Parse("00") // works fine x = Int32.Parse("000") & ...Show All
Visual Studio Team System Name instead of UserID in Assign To dropdown list
Add name instead of userID in Assign to – who knows a devlopment teams (10-20 people) all userid’s xx98237d. Hi Daniel, Thanks for the reply, it was a AD side issue as the display names for some users were mentioned incorrectly. Regards, Vijay ...Show All
Visual Basic Custom Action -EXE how to abort install
Hi All, I am experimenting with deployment of a VB solution and specifically with a custom action in the deployment project. The custom action EXE works with SSE 2005 databases and verify special encrypted files required by the solution. Every thing works fine but I would like to be able to abort and reverse the installation from within the custom action EXE. I guess the question is simple but here it is : Can we abort the installation from a custom action EXE If yes, how Thank you very much. I'm pretty sure the right exception to use is a System.Configurati ...Show All
Windows Forms Check for valid filename
Hi All In my app I'm prompting the user for a filename for a file that will subsequently be generated, i.e. it doesn't exist yet. I am sure there must be a method that will allow me to check that the filename entered is valid, but I cannot find one! Any help greatly appreciated. Many thanks Stuart (gingerbbm) You can use the System.IO.FileInfo& ...Show All
Visual Studio 2008 (Pre-release) XAML, RenderTargetBitmap - picture disappears from image after load testing
I'm developing a simple ASP.NET handler that returns image that is rendered using XAML on server side. The problem that after stress testing picture disappears from returned image (but empty image is still returned). The picture here is XAML canvas (I put it to the bottom of the message) with different shapes and glyphs (rectangles with gradient fill, lines and text with digits). I tested on Windows 2003 (two processors, four processors), IIS 6.0, .NET 2.0, WinFX RC (February CTP), emulated 250 concurrent users. I have the following code: public MemoryStream CreateImageStream(String xaml) { object obj = System.Windows.Mar ...Show All
Visual Basic How to display login form...???
Can anyone help me out, this is urgent ... I have created a login form, how can i display the login form each time when windows start up I mean i want the form to be display once the windows logon form is displayed... or anyways i can replace the windows logon form with my login form p/s: sorry for my bad english explaination ... Thank you Grant, you really provided so much info for me.... i think i'll learn from there .... i'm still new in IT lines ... thanks for ur suggestion ... any further question i'll ask here, and i hope u won't mind to answer, would u ...Show All
Visual C# How do I clean out the Recycle Bin?
How can I do that Matt Matt, you can also call the SHEmptyRecycleBin API, that will allow you to select which recycle bins you want to clear, will provide a confirmation prompt, a sound, and the progress dialog (all of which options can be disabled). A rough signature for the API would be: [ DllImport ( "shell32.dll" )] public static extern IntPtr SHEmptyRecycleBin( IntPtr hwnd, [ MarshalAs ( UnmanagedType .LPTStr)] string path, uint dwflags); you may also need to declare the constants (from shellapi.h), if you want to customize the behaviour: public const uint SHERB_N ...Show All
SQL Server Foreach loop with parallel execution
Is is possible to get the iterations in a foreach loop to run in parallel What I need to do is to spawn an arbitrary number of parallel execution paths that all look exactly the same. The number is equal to the number of input files, which varies from time to time. Any help is appreciated! Regards, Lars Ronnback Nope. This feature was available in some beta releases, so you may notice it references in newsgroups and forums. But it was cut due to complexity and quality issues. ...Show All
Smart Device Development Device deployment - How to prevent activesync?
When deploying PocketPC's, how does one prevent Activesync from loading (user from docking and modifying file system) Thanks! The simplest solution would be to deploy the PDAs without their docking cradles. Most have the ability to be re-charged without needing to be in the docking cradle. Or you could, on the PC side, disable all the USB ports and thereby prevent a connection. Of course, if you need to exhcange data with a PC, neither of these options would be viable. Other than that, I don't know of a way to secure the device, but if anyone knows a way, please post! ...Show All
