Red2034's Q&A profile

• .NET Development Parameterized queries

  When using a parameterized query such as: SELECT LocationID, StreetNum, StreetName, rowguid FROM tblLocations WHERE (StreetNum = @StreetNum) AND (StreetName LIKE @StreetName) Is there a way to automatically add % to the beginning and ending of the parameter I've tried the following command: SELECT LocationID, StreetNum, StreetName, rowguid FROM tblLocations WHERE (StreetNum = @StreetNum) AND (StreetName LIKE '%' + @Stre ...Show All

• SQL Server creating backup of secure backup of database

  how can create a secure backup of a database in Microsoft Sql Server 2000 i want to perform this task from Visual Basic. Regardless of the interface used to request the backup, you end up with either a TAPE or disk file. The only way to make this data secure is to physically protect the media on which the data is stored. For disk backups, you can encypt the backup file.  SQL Server does not provide its own encryption, but you ...Show All

• Windows Forms docking ...

  why can we not have two controls on a form and both have Fill set for Dock property, so that when one control is collapsed the other one takes the remaining area and vice versa  In the <A HREF="http://www.windowsforms.net/Appl ...Show All

• .NET Development web service access issues

  first I'd like to apologise if I'm starting a duplicate thread here, but after searching for a half hour I was unable to solve this issue. I am new to developing in a microsoft enviroment, more used to unix so please bear with me. I have written a web service using visual studio 2005. Just a sample to try get things working. I then consume it in a windows app (also in VS2005). Both using C#. at first I was using the ASP.NET development web serve ...Show All

• .NET Development drag and drop forms leave out functionality

  1.  There is no error catching code in the bindingNavigator toolstrip buttons. 2. There is no canceledit button.  It's a pain having to add one each time. 3.  I would like to make my own control that includes not only the canceledit button but all the code I want.  I have no experience whatsoever in inherited controls or user controls.  So,    a.  Is it possible to include code in a user control   ...Show All

• Visual C# Visual C# Look and Feel nice in XP, ordinary in 2000, why?

  Hi, I downloaded and am running Visual C# Express on my Windows 2000 machine. At first, I was slightly taken aback by the clumsy, clunky look of some of the dialogs in the IDE itself. That is, some of the buttons were strangely large and the size of some dialogs just didn't come anywhere near the professional, smart look of say, Office 2000. For example the "Edit Rows and Columns..." dialog if you right-click on a TableLayout panel. I'm not ...Show All

• Smart Device Development How Do you modify the Schema of TASKS DATABASE on WM2005?

  Does anyone know how to modify the EDB schema of the "tasks database" on WM2005   Once the device boots shell32.exe already has mounted and has locks on the database preventing me from appending new columns to the schema.  On Pre-WM2005 the developer could add columns without problems, but with WM2005 you can't - Does anyone know how to force shell32.exe to close all handles/sessions to the "tasks database" Thanks, Jim Row Dallas TX ...Show All

• Visual Studio Team System Team Foundation Server site not extended!

  If I browse my Sharepoint Central Administration site I see that my Default Website is extended properly (it reads 6.0.2.6411 under Version). However, the Team Foundation Server site is not. How can I extend it When I tried this before (I reinstalled everything now) it refused telling me that a database is not ready (I can't recall exactly). Is there a proper way for doing it Should it actually be extended at all ...Show All

• Windows Forms How to host progressbar into DataGridView?

  MSDN give an example of how to host DataTimePicker into DataGridViw. I read it and I'm not clear enough to do it with progressbar. I want some further comments to put progressbar into DataGridView, because progressbar is not editable. Thanks in advance for your help! ...Show All

• .NET Development plain text serializer

  Hi there, Suppose I have plain text data in a csv file, sort of CT-3227,50,$280,07/12/1998,John Doe If I know that the entries are separated by commas, I can use a FileReader to scan for commas, create a String with the content and call Parse with the corresponding entry type (which is known in advance).  However, what happens if I encounter a number like 1,500 meaning "one thousand five hundred"   e.g. UInt32.Parse( "1,500" , Global ...Show All

• Visual Studio Team System Workitem creation

  I am trying to create workitem object 1.when creating the workitem object using public WorkItem(WorkItemStore store, uri) constructor getting an exception giving message as uri 2.when creating object using constructor public WorkItem(WorkItemStore store, int id) constructor than  either overriding the existing workitem or getting exception not able to create workitem object with new id. Is there any way to create new workitem object. ...Show All

• SQL Server Groupings in Matrix Layout?

  Hello, I am trying to come up with a Matrix report using RS 2005 that looks like this one below. I have row data: question, columns data: Ethnicity and Gender, detail data: Gender average response and Ethnicity average reponse. I utlilized Report Wizard to create a report in a Matrix format , however I wasn't able to have Gender and Ethnicity column on the same line. The report wizard groups columns so Gender is a subset of Ethnicity ...Show All

• SQL Server Standards for Custom Component Development

  Hi, Maybe I didn't search hard enough on BOL, but does Microsoft have a documented set of standards regarding custom component development for SSIS. Things like: - extend this base class, implement this interface - override these methods - follow these naming conventions - best practices Thanks, - Joel Joel, Not all of this falls entirely into the realm of standards, like the API stuff. ...Show All

• Visual Studio Team System Bug: Get Latest Changes causes VS.Net to lose focus.

  This hardly matters, but when you select to Get Latest Changes in VSTS.Net from Foundation Server  VSTS.Net falls in z-order to the back window. It's a quirk. This is indeed very annoying.  I am looking into a solution for this.  As James mentioned this happens to us in our daily usage as well.  Please let us know if you see this behavior in anything other than one of the progress dialogs (get, checkin, etc.) as we are ...Show All

• .NET Development VS 2005 hardwa AMD or Intel?

  I have VS 2005 Beta2 installed on my P4 2,4MHz machine and now I'm planning to buy a new machine with x64 processor. Can anyone suggest what to buy: Intel or AMD chip. Which is better for VS Regards Go with AMD, they own the x64 instruction set and the OS was built against their processors. Intel have licensed x64 from AMD and built their own processors. Personally I see no reason at all to use Intel, unless th ...Show All