Jonathan Sampson's Q&A profile

• SQL Server Query Analyzer, Slow Query responses

  Hi there Running query analyzer against two different server. the first only need 1-2 secs to return the query result, the other return 7-8 secs for the query result. plz advice what could cause this slow performance thx there can be many reasons, connectivity,amount of data (on 2 servers), indexes (on 2 servers), statistics updated on one and not on another or even fragmentation of data segments... thus for a query to perform at the same rate many factors need to be considered by the DBA.. ...Show All

• Windows Forms XML tree Mapper

  Hi, I need to privide my users with a visual interface do map values from diferent xml messages, just the the biztalk Mapper. e.g: MessageA.FieldX goes to MessageB.FieldY , and so on .... something like the biztalk mapper Any thing like this really appreciate that. tks D ...Show All

• Visual Studio Manual binding example

  I have a lot of RDL reports that I would prefer not to convert to RDLC. www.gotreportviewer.com mentioned manually binding data sources to these reports, but I could not find an example of how to do this. Does anyone have an example of this Thanks At runtime ReportViewer control can't tell an RDL file from an RDLC file. The extra information in RDLC files is relevant at design-time only. ...Show All

• Visual Studio Express Editions error??

  I can't find that error in my code. Can anyone tell where to look ArgumentException was unhandled Cannot bind to the property or column Data on the DataSource. Parameter name: dataMember You’ll need to provide a bit more information such as the data type of the Data column of the table that you are binding to for the DataMember of whatever object you are trying to display your data within. ...Show All

• SQL Server Parameters for Report Builder

  Is there a way to set parameters for a Report Model I have a database that includes data for a lot of users and I want to be able to use a Report Model but only allow the user to see data related to their UserID when they are using Report Builder to build a report. Is this at all possible Would I have to set up some custom authentication Thanks for any help. Please take a look at Model Item Security. http://msdn2.microsoft.com/en-us/library/ms156505.aspx ...Show All

• SQL Server Transactional Replication Problem

  I have set up a Portal database replication (central subscriber topology) In essence, the replication architecture implemented is 4 (Server 1 - 4) servers replicating to one server (Server A). The 4 SQL servers are setup to be Publishers and Distributors and Server A is setup as a Subscriber. The replication type implemented I used is Transactional replication with replication to update the data at Server A as soon as a change in the data has occured on one of the Servers (1 -4). As Publishers, the servers (Servers 1- 4)will organise their data into publications and make the data available for replication to the Server A. They automatically detect which data has changed and maintain information about the changes. As Distributors, the serve ...Show All

• Visual Basic syntax error

  Hello to all, When I try to run an application that I am working on I get a sytax error with the line of code being referenced. Error code: syntax error: missing operand after '=' operator. Line of code referenced: Me.ChannelBindingSource.Filter = "FolderID = " & FolderComboBox.SelectedValue I have looked at this until I am ready to pull my hair out. Could someone please point me in a direction that I haven't been able to since I must have my blinders on. Thanks Spidermans-- Yes in the data base there is a space between the & and FolderComboBox.SelectedValue and also the channel is spelled correctly. I mis-typed it here. I have retyped the line several times with no success. I will try the suggest ...Show All

• Windows Forms Error - System.IO.FileNotFoundException When text with Spaces entered in Custom User Interface

  Hi I am having Windows Service and a setup project for this service. In set up project I am taking inputs from user using UserInterface (TextBoxes (C) ) and Custom Action. However when User entered any thing with spaces in it my installer fails giving following error System.IO.FileNotFoundException: Could not load file or assembly 'file:///C:\WINDOWS\system32\With' or one of its dependencies. The system cannot find the file specified.., (NULL), (NULL), (NULL). I am having followin code in my Installer class public override void Install(System.Collections. IDictionary stateSaver) { System.Diagnostics. EventLog .WriteEntry( "My Setup" , "Install" ); StringDictionary myStringDictionary = ...Show All

• Visual Studio 2008 (Pre-release) January Orcas CTP

  Hi! I have download and installed January Orcas CTP on virtuell server and now I can start Visual Studio Orcas 9.0, but can not find any Linq project to start playing. I am a first timer about Linq. I checked and there is a version 3.5 Net framefork installed under Windows. Regards Hello, I blogged about this when it got released, and done a few pointers on how to get started http://blog.benhall.me.uk/2007/01/orcas-january-ctp-lack-of-linq.html However, Linq To SQL (like SQLMetal) is released in a Feb CTP, but Linq to Objects and Linq to XML is useable. Hope it helps. Ben ...Show All

• Visual C# operator overloading vs operator overriding

  what is the difference between operator overloading and operator overriding thanks in advance for ur replies No they are distinct operations irrelevant of whether they are methods, properties or operators. Only instance methods that are declared virtual can be overridden. Any method, instance or shared/virtual or non-virtual, can be overloaded. Perhaps an example will clear things up: struct Complex { //Overload constructors public Complex ( float real ) { m_Real = real; m_Imaginary = 0 ; } public Complex ( float real, float imaginary ) { m_Real = real; m_Imaginary = imaginary; } private float m_Real; private float m_Imaginary; public float Real { get { ...Show All

• SQL Server Hiding a zero value

  How can I hide or suppress the 0-values (zero) in a report Use the expression =iif(Fields!FIELDNAME.Value = 0, True, False) at the Visibility expression field in the properties of the textbox. Kind regards! Marius ...Show All

• Windows Forms Newbie needs help: Accessing a row of a datagrid (C#)

  Hi, ive searched online and through the forums for a couple hours and i havent found any help for my problem, so i decided to start a thread. Im programming in C# (still learning it) and here's the situation: I have a form with a combo box and a datagrid. Ive populated the combo box with names from a column in a MS access db table named Employees. When someone selects a name from the combo box, i would like for that employee's information (a single row from the Employees table) to display in the datagrid. I filled a dataset object, and then a datagrid object with the Employees table. I can find the index of the name selected by using the combo box's SelectedValue property, but i dont know how to access that particular index in the ...Show All

• Visual C++ debugger error

  It's called "No Debugging Information" error. It says "Debugging information for 'name.exe' cannot be found or does not match. Binary was not built with debugging information." I get this when ever I hit the debugging button. Can anyone help me with this Thank you for all your help on this sven. After doing some more research I discovered that along with the stuff you told me to do, I also have to set Optimization to 'disabled', and my debugger is working now. ...Show All

• SQL Server question on package configuration

  Hi, Programmatically, how will i be able to know if a package is using package configurations Thanks. if the package is using package configurations, i need to get the values from the connection strings in the ssis configuration table. if the package is not using package configuration, i need to get connection strings from the connection objects. also, from a script task, how will i get the value of a package configuration variable ...Show All

• Internet Explorer Development Document Complete event for multiple frames

  Forgive a newbie-ish question. :) I find that with complicated multi-frame pages (e.g. www.cnn.com) I get a document complete event for every single frame. Most of these are ad frames of course. Is there a way to obtain the "real" URL of the site, i.e. www.cnn.com in this case, without having to deal with all the other frames Alternatively is there a status flag that identifies the final frame, or is it safe to assume that the last frame that I receive notification of is the "real" site frame I have also found that with both IE6 and IE7 I occasionally never receive a document complete event for the "real" frame, in other words I get a dozen or more ad-based frames and nothing else, and yet the site correctly ...Show All