AlexBB's Q&A profile

• Windows Forms Problem after moving WS to QA Server

  I moved the webservice from localhost to our QA server. Now I cannot connect at all through the log in, alothough I can test it fine through a browser (get a ticket, return a ds).  What do I need to do to get the web service up and running. I changed the host information from localhost to the servername. I didn't change the namespace&nbs ...Show All

• .NET Development How can i turn "validator" off ?

  Hi When I load a XML document which header declare "dtd" file using XmlTextReader (Ex :<!DOCTYPE PLAY SYSTEM "play.dtd">) if dtd file doesn't exist(play.dtd) it will error How can i turn "validator" off Thks XmlReaderSettings settings = new XmlReaderSettings (); settings.ProhibitDtd = true ; XmlReader reader = XmlReader .Create( "input.xml" , settings); ...Show All

• Visual Studio DataSet with multiple sources for ReportViewer

  Hello, I need to create a report with data returned from two separate Sql Servers. I created one dataset and put two datatable/tableadapter objects in it. Each datatable retrieves data from a single Sql Server. Should I combine the two datatables in the dataset I believe for one report I should only have one dataset. How do I combine the two datatables to create one output(for the single dataset) which then I can specify to populate the report. Also, the output needs to be a combination of the two datatables. I'm sure this is confusing as I'm new to this and not sure if I'm using the correct terminology. Here is an attempt to outline ...Show All

• Visual Studio Tools for Office working with sql server data in ms excel

  Hi, I will give a brief first. I have some data in sql server and i want to put it into ms excel. The file would be first reviewed by admin who would have the functionality of sql server available. When its been emailed to users they will not have sql server available (sometimes the file might be send on a disk). When admin receive the file back it will again be reviewed and then saved back to sql server in different tables. Now my questions are : 1) what is the best way to do it, Do i open a office project from vs2005 and then choose ms excel workbook or any other way 2) How to show the data in excel in combo boxes and afterward ...Show All

• Windows Forms how to control datagrid scrolling with two push buttons

  I have an interesting user requirement for the project I'm working on.  Our users want a datagrid to display the data (that's the easy part).  However, they don't want scroll bars.  Instead, they would like a "Next" and "Previous" button to control scrolling (i.e. if the datagrid would normally display 10 records per page, hitting "Next" would display records 11 - 20, etc.). If anyone has any ideas on how I can control scrolling of a datagrid with buttons, I would appreciate the help. Thanks, You will need to turn off the vertical scrollbar.  The DataGrid's scrollbars are protected properties of the DataGrid, so ...Show All

• .NET Development how to format xml string with an xsl stylesheet

  Hi, I have a string that is in an xml format <items><num>5</num><text>sometext</text></items> I want to transform that string somewhow using my xsl document listed below and attach it to the body of an email. I was trying to use the code below but the xmldocument load does not take a string. How can i go about accomplishing this. XmlDocument docXml = new XmlDocument(); docXml.Load(sb.ToString()); XslCompiledTransform docXsl = new XslCompiledTransform(); docXsl.Load("xslFormats.xsl"); Thanks! Alex I 'm not sure what you are trying to accompli ...Show All

• Visual Studio Print a crystal report from two trays.

  Hi, All I want to print a crystal report from my VB.net wins application. I want to print first two pages from upper tray with double side and the rest of them from lower tray. Or, printer can pick up first page from upper tray and second pages (to end ) from lower tray. Whatever I setting up the paperSource, printer will always picks up the paper from upper tray for whole report. I am using crystal report embeded in .net1.1 Here is my code: Dim objEnvoiceReport As CrystalDecisions.CrystalReports.Engine.ReportDocument '  Getting datasource and bind to objEnvoiceReport... objEnvoiceReport.PrintOptions.PrinterName = our ...Show All

• Visual Basic Using HTML code with Visual Basic 2005

  The HTML codes creates a basic web page... can I use this code to display the page with the web browser Any ideas Thanks. Okay, I have a problem, how do I specify this line that already has " quotes in the document.text line Thanks. <input type="hidden" name="cmd" value="_xclick"> ...Show All

• Visual C# Create extended stored procedure

  Hi, You could present structure of a code extanded stored procedures for SQL 2000 on C# Thank It is not possible to write an extended stored procedure for SQL 2000 using C#. You will need to use C++ Regards, Vikram ...Show All

• SQL Server active/active clustering

  how does an active/active cluster work with sql server What about both servers trying to write to the same database files Each has their own locks. How does active/active work with such constraints If you were going to do that, there really wouldn't be any point in configuring clustering at all. You would simply drop in Database Mirroring with a Database Snapshot created against the mirror database. Actually gives better fault tolerance than clustering, because you have two copies of the data and it gives better availability, because mirroring reacts more quickly than clustering does. And, you wind up in ex ...Show All

• Visual Studio Can't get LAN Booster client to use server

  When loading a solution in VC++ 2005 (RTM), I get the message "Unable to use SourceSafe LAN service, performance of SourceSafe operations will not be optimal".  SSService is running on the server and there are no errors in the application log of the server related to it.  The only entry is a message indicating the service has started. The server is a Windows 2003/SP1 system that is NOT running Windows Firewall or any other firewall.  The client is a Windows XP Pro/SP2 system.  I've not tested any other clients thus far.  I'm trying to get a test system working first. The VSS database was originally created with VSS 6 ...Show All

• .NET Development WSE 3.0 problem

  I am developing a web services app in compact framework and want to use only MTOM feature of WSE 3.0 for dending data but if possible would love to use other features also I enabled WSE 3.0 in my web services app but as soon as i built my code I got a lot of errors. So I tried msdn and found foll article . This did a great work and most of the errors were removed except one "The type 'System.Web.Services.Protocols.SoapHttpClientProtocol' is defined in an assembly that is not referenced. You must add a reference to assembly 'System.Web.Services, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' in Reference.cs. Is ...Show All

• .NET Development Trouble getting value from xml file

  Hi I am new to c# and xml but progressing nicely (I think) anyway I am reading in an xml file and then extracting information from a particular tag and rewriting it to a new file. I have almost got it but I am having a problem getting the value from the element and then writing it as an attribute to the new one. Code is while (reader.Read()) { if (reader.Name == "text" && reader.NodeType == XmlNodeType .Element) { writexml.WriteStartElement( "text" ); writexml.WriteAttributeString( "id" , "value from element here" ); // this bit writexml.WriteAttributeString( &qu ...Show All

• SQL Server SSIS package execution question in SQL agent

  Hi there, I have been trying to schedule a package I design to run off hour, but unable to do so. Here is a strange issue: 1. I was able to fully run and complete the package through VSS. My package has three steps and I have on complete arrows from one step to the next... When I run it, it does what I expected in SSIS designer. 2. I was able to deploy and run the actual package by double click on the file system and it runs successfully through Execute Package Utility. So my package does loop through a file folder and insert records from within the folder through execute SQL task to a SQL table...etc. Typically it takes a while ...Show All

• Visual C# addon for internet exploere

  hi i want to use VS 2005 to create add on for internet exlporer what is the tool that i need to use from VS2005 my idea is to create a tool bar as google and then i can use it to search the net for any word If you want to create a toolbar, you need to create an BandObject, here is a short list of articles that will help you out: Extending Explorer with Band Objects using .NET and Windows Forms RSS bar using BandObject ...Show All