Shirvo's Q&A profile

• SQL Server "FOR XML EXPLICIT" query Works on SQL 2000 but same does not...

  We are using a stored procedure which uses FOR XML EXPLICIT and it works fine with SQL Server 2000 but doesnt work with SQL Server 2005. Can anyone help me out in understanding the reason behind such a behavior and any possible solution. Please find the details of the problem below: The procedure runs fine in SQL 2000 the input xml and gives us the correct XML: SELECT 1 AS TAG, NULL AS PARENT, [TEST:mailboxaddress] AS [mailbox!1!mailbox-name!element], [TEST:status] AS [mailbox!1!mailbox-status!element], NULL AS [user!2!title!element], NULL ...Show All

• SQL Server I broke my MDAC 8.2 RTM on SBS 2003. Have file mismatches that I can not fix. Help!

  While working to try and install and evaluate 3rd party versions of the SQL Enterprise Manager on our SBS 2003, I managed to break our MDAC installation and the results are non-functional Veritas BackupExec (needs the SQL MSDE instance to work), I seem to have broken RAS in the process and our Web access for Outlook 2003 broke too. It seems there are many dependencies on MDAC working that have now failed with this problem I created. What I need is help to replace the 5 files that Component Checker (cc.exe) has identified as being mismatched against the expected versions for MDAC 2.8 RTM. This is supposed to be a part of the Windows Small Business Server 2003 installation and I hear that the Veritas setup process may install this too. To da ...Show All

• Visual Basic Question about VB2005 connect to SQL2000(2)

  I want use a variable to grab a string from a text box, then pass the variable into data base to check if any record is matched and then display result in a data grid. How can i actually do that do i need to create a specific adapter and dataset for that well you can, dataAdapters are really used for when you are wanting to fill a set of records into a dataset or update records in the given dataset to the database. So to me, looks like you want to show the records that match the variable correct if so, you could use a dataset/dataadapter but if its just 1 record you are after then it may well be inefficient. There are many examples on the forums on how to use a SqlDataAdapter if you are wanting to go t ...Show All

• SQL Server Help reporting services

  Hi, I have some problems in sending parameters from Reporting Services to a Web Service. The issue is that my parameters are arriving with the value of 0. Does anyone have a code snippet or an idea of how to send correctly the parameters from Reporting Services to the Web Service. Here is the web service which takes 2 parameters of integer type. The web service invokes a method which returns de data in a Dataset: using System; using System.Web; using System.Web.Services; using System.Web.Services.Protocols; using System.Data; using LibReporte; using System.Xml; using System.Xml.Serialization; namespace WsReporte { [ WebService (Namespace = "http://tempuri.org/" ...Show All

• Windows Forms Add Form Control Button

  How to create additional button on Form title like Minimize, Restore and Close button. My target is to detach and attach Form to MDI form using swichable button like Restore. Other ideas or solution for this task are welcomed. Yes, that is what i want. I can put a button on mdi form for detaching MdiChild form from Mdi Parent form. But I can't do the same for attaching. That is why that button should be on the form. But if i put anywhere on the form, i need to change many form's design. That is why i thought on puting the butoon left from minimize button or for some forms left of close button. Also this way will be more user friendly. ...Show All

• Windows Forms Icon from path in treeview

  Just would like to know how to do that (the icons) http://miranda.predialnet.com.br/imagens/iniciarewido.jpg In my app i did: http://miranda.predialnet.com.br/imagens/iniciar.jpg Assumes both a treeView1 control and iconImageList control (16x16 8bbp images) have been added the form and the treeView1.ImageList has been assigned iconImageList in the Designer: System.IO. DirectoryInfo directoryInfo = new System.IO. DirectoryInfo ( @"c:\windows\system32\" ); System.IO. FileInfo [] files = directoryInfo.GetFiles( @"*.exe" ); if (files != null ) { foreach (System.IO. FileInfo file in files) { String fullPath = file.FullName; Icon icon = ...Show All

• Architecture Performance issue become worse upon split out Web Applications into web server and DB server

  Hi, Currenly i'm faced web applications (in web server, 2GB RAM) with performance issues upon seperated database(4GB RAM) and web application into 2 machines. Before spliting, it have performance issue where IIS need to be reset when "Server is un-available" or hanging occur. In this case I proposed to split out for better performance and hope to resolve the issue. Now, after spliting, users complaint that the responce time even worst that before. Any one have this problem before Any suggestions to help * DB server with SQL Server 2005 and SQL Server 2000 installed but i only used SQL Server 2000 and both web servers with Window Server 2003 installed together with crystal report 10. Thank you.. ...Show All

• Smart Device Development Accessing Contact Categories(all categories) in Compact Framework

  I have outlook object. I was able to retrieve each item in the contacts. If I want to create new contact from my application, I want to have to ability to select Category for that contact. What is the way to retrieve list of all categories using Compact Framework 2.0 VS2005 WM5.0 Thanks, Vijay Sadly this isn't exposed through the WM5.0 managed APIs. If you are comfortable working with the native POOM interfaces (using COM interop in .NETCF 2.0) you need to get the IItem interface for the Contacts folder. Then retrieve the PIMPR_FOLDER_CATEGORIES property. There is a native code example in the SDK Help file on the Shared Property ID's topic. Peter ...Show All

• Windows Forms Masked DataGridViewEditControl

  Can anyone point me in the right direction (or show a sample) to have a masked edit control as the editing control in a datagridview cell I have a data source that stores an int which represents minutes. I want to display that and have users be able to enter it as 'HH:MM' so it needs to be converted before display, shown in a masked edit control, and converted back to minutes after editing. Thanks, Ken There is a c# example masked edit column in the datagridview faq samples . I placed a vb sample on the vb-tips website . ...Show All

• SQL Server Matrix control

  Hi all, I'm using matrix control as my reporting tools. But i found one trouble, how can i do my matrix become like this. Product A Product B Customer Price Qty Price Qty Customer A 10 10 140 160 Customer B 12 120 120 160 Customer C 10 10 110 140 The price and qty is the static column, and i would like to make the static row also. (show in red color) but i can't. Please help... Thanks Kendy Hi Idanle, As u can see from the excel file, the tab defect page. The "Customer" header will alwa ...Show All

• Visual Studio 2008 (Pre-release) How does WCF 3.0 support WS-Eventing?

  MSDN version of the WS-Eventing spec: http://msdn.microsoft.com/webservices/webservices/understanding/specs/default.aspx pull=/library/en-us/dnglobspec/html/ws-eventing.asp Does WCF 3.0 support WS-Eventing ...or are the patterns in the MSDN Mag article " What You Need To Know About One-Way Calls, Callbacks, And Events " ( http://msdn.microsoft.com/msdnmag/issues/06/10/WCFEssentials/ ) the best way to implement a publish/subscribe pattern using WCF 3.0 The article is clearly written and relatively easy to understand but I am suprised how complicated the overall patterns are. I would have expected WCF 3.0 to have something similar. Bradrover, Thank you for a link to my article. This article described implem ...Show All

• Visual C# Screen Resolution in C# 1.1

  Hello, I designed an application in c# windows forms (.net 2003). I have some doubts about screen resolution. 1. When my application is starting, i want to change the system resolution depends on my application. 2. Changing the application settings depends on System resolution.Which is better one and give any ideas about changing the resolution. You can discover the resolution of the screen your window is on by using the Screen class. Screen screen = Screen .FromControl( this ); // this is the Form control MessageBox .Show( string .Format( "Width = {0}; Height = {1}" , screen.Bounds.Width, screen.Bounds.Height), "Screen Size" ); MessageBox .Show( ...Show All

• Windows Forms Converting a windows form (and other) object(s)?

  I am writing a c# DLL and want some functions to create windows forms and windows form objects. The DLL is for a language that only has standard variable types such as int, float, double, string, etc. So I cant really input an object as a function parameter. Is there a way to get some sort of string or integer handle for an object Also, if anyone could give me an example to write a button creation function that returns a handle I would greatly appreciate it. I'm afraid there's no magic way to do this. I was thinking something fairly basic, along these lines: public class Namer { static int nextId = 1; public string MakeName( string nameBase) { s ...Show All

• Visual Studio Express Editions Making a kind of word

  Hello, I am makeing a kind of word but i don't know how i do this: add rulers possition of the text (left,right,centre) add symbols decrease, increase bold,italic,underline findform textcollor plz can somebody help me Font Formatting, Textcolor etc. sizing etc. You can use the RichTextbox control. This allows you to adjust the formatting of the text - whereas the standard textbox control is much more limited. You can do a simple web search on VB.NET + Richtextbox + Formatting http://www.google.com/search hl=en&q=vb.net+%2B+richtextbox+control+%2B+formatting and this will reveal numerous URL's with information on ...Show All

• Visual Studio 2008 (Pre-release) User controls from external dll in toolbox

  I'm trying to set up a multi-project WPF solution, but can't get user controls to work: I have one WPF exe, with just a form, and a number of dlls which defines the controls I'll be using on the form - but I can't get the user controls to appear in the toolbox (I get "there are no components in..." when I try to add the dlls). What should I do to make them available Thanks you can add mapping like this in the XAML file where you want to add the controls xmlns:local = " clr-namespace:your namespace;assembly=your assembly " and add control like this <local:MyControl/> ...Show All