Frank the Tank's Q&A profile

• Visual Studio Express Editions Listbox

  I have a listbox that get info from a databse access, it only show the name, but I want to show name and surname in the listbox. Me .lstNameAndSurname.DataSource = Me .BindingSource1 Me .lstNameAndSurname.DisplayMember = "Name" I have try to get it to work, but I am doing something workg Thanks I did the following 1. Went to listbox on form 2. Went to Add Query in the Listbox Tasks 3. Make a new Query and with this info select Naam+''+Van as name from Sondagskool 4. When I press Ok it gives me the following info The schema returned by the new query differs from the base query. I am quit a dummy here as I don't know what to change or do here ...Show All

• Visual C++ Help: error C2065: 'XConn' : undeclared identifier

  This seems elementary, but still has me stumped. This happens in VC++ 2005 Express. XConn is a public managed object in the main form (public ref class Form1) of a Windows CLR application. I'm attempting to access it in a method of another managed class. I always get that error message. The class browser appears to show it as a "variable" of Form1, but specifying the scope of XConn produces the same error message for Form1. Form 1 is instantiated in the main cpp file as: Application::Run(Form1()); I would assume that after instantiation, the object XConn is accessable. But there seems to be no way of telling the compiler to look for this somewhere. I thought public members - managed or not - were supposed to be acessible to all parts of a ...Show All

• Windows Live Developer Forums Showing latitude and longitude lines on the map ?

  Hi Is it a built-in functionality to show latitude and longitude gridlines on the map   or does anyone know how I can do it in some other way I am a bit new to Virtual Earth , but I have a windows app, that is using Virtual Earh to show positions for fishingvessels and those who are using it wants to have gridlines on the map, because they are used to it from other software they have used   ( GIS stuff ). The vessels are sending xml messages from wherever they are fishing and into a server. Their position are inside this xml message and I show them on the map. Stein   You can draw them yourself with a few lines of code in any colour you like! check out: ht ...Show All

• SQL Server composite nonclustered index

  Hi everyone, I have some problems on composite nonclustered indexes. I could not exatly understand their logic. In my opininon, suppose that we have a table called Order and we create a composite nonclustered index on this table for OrderID column and OrderDate column. So I am using this query; SELECT * FROM Order WHERE OrderID > 12 ORDER BY OrderDate So in here, I think our first research is based on OrderID and ten after ordering our data pointer according to the OrderID and then our index is converted to an index which is based on OrderDate while performing ordering. So is this correct Would you please explain this Thanks Hi, Thanks for your reply but it came to me a little bit confusing. By saying this, " Then the optim ...Show All

• SQL Server Speed of updating changed ipo all fields

  Is it faster to update only the changed fields of a record in a table in place of updating all fields, that is set changed one's to new values and the other fields to their existing values Ex. if only the name of a person is changed then we can have update tblPerson set name = 'newname' vs update tblPerson set name = 'newname', surname = 'oldsurname', address1 = 'oldaddress1'...... Maybe I should explain a bit more. We have a middle tier class that generate dynamic sql at run time. This class can determine what percentage of fields has changed and can accordingly decide to update all fields or just the one's that has changed. Let say anything above 60% it will generate sql to update all and anything below ...Show All

• SQL Server Parameter = "Select All"

  Hi, I am trying to pass an url to my report. In that url I want to pass my multivalue parameter with "Select All" as the parameter value. The probelm is, I don't know what value should I pass in the url which will be equal to selecting "select all" in the reporting services. I hope I am making my self clear, I case you have any doubts please ask me. Thanks, -Rohit ...Show All

• Windows Forms signing manifests at customer site

  Hi, I have a clickonce enabled app. that I want to deploy on a customer's computer. I can only get the DeploymentUrl parameter of the deployment manifest at the time of deployment (i.e. at customer site). Signing the manifests on my machine and then deploying the app. at customer site will not work since the deployment manifest will get modified once the proper DeploymentUrl parameter is supplied and requires re-signing. Installing my certificate at the customer's computer (with the private key) will solve the problem since I can then modify the manifests and sign them. But this is not a good solution in my opinion since it would compromise the security of the private key. Can someone please suggest a solution for this ...Show All

• SQL Server Connetion VS2003 C# Web Service to Sql Server 2005 Express

  Hi, I'm reaching the end of my tether here. I'm writing a Web Service application for my MCAD course in VS2003 which will connect to a SQL Server 2005 Express instance to access data. I can connect to the instance through the management suite, and through Visual Studio 2003. For some reason, when I try and manually connect through the web service, I get a page cannot be displayed error. When debugging, it falls over at the connection code. Here's what I have: < appSettings > < add key ="ConnectionString" value ="Integrated Security=SSPI;Initial Catalog=OfficeSupplies;Data Source=SGODRICH\SQLEXPRESS;"/> </ appSettings > in web.config, and in my application: // Create a connect ...Show All

• SQL Server Sanity Check/Question About Idea

  OK can someone look at this idea and tell me if it sounds like it would be work and be a good way to do things On our Virtual Server machine I have 4 Server's setup. All Running Windows 2003 Standard. Server1 - SQL Server 2005 Standard Server2 - SQL Server 2005 Standard Server3 - SQL Server 2005 Express Server4 - SQL Server 2005 Express Now I would have Server1 & Server2 in a DB Mirror Mode. With Server3 being the witness. When Server1 Fails Server3 would tell Server2 to become primary. Then when Server1 comes back it gets updates from Server2 and vice versa if Server2 fails. Now Server4 I was hoping to remove some of the processing that is done (currently via DTS in SQL 2000). This scheduled jobs will get the upda ...Show All

• Windows Forms The requested URI is invalid for this FTP command.

  Hi, I keep getting the error "The requested URI is invalid for this FTP command." when trying to upload a file from local machine to the FTP server using code below in C# 2.0. I am getting error on the bold line below. I would appreaciate if someone can guide me to proper solution. thanks Mahesh public void Deliver() { FtpWebRequest request = (FtpWebRequest)WebRequest.Create(destinationHost); //destination host is ftp://actual IP address/ request.Method = WebRequestMethods.Ftp.UploadFile; request.Credentials = new NetworkCredential(userId, password); // Copy the contents of the file to the request stream. StreamReader sourceStream = new StreamReader (sourceDirectory + sourceFil ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Maximized window frame rate issue

  In my game, if I resize the window to fill the entire screen without actually maximizing the window, it runs at 59 FPS. If I hit the maximize button for the window, which isn't really changing the window size at all, since the window is already filling the screen, my FPS drops to 24 FPS. So with the same size window and the same code, the only difference is that the window is maximized. Any idea why this might be happening Bill Well as you probably know, Windows Vista is currently an unsupported platform for XNA as stated in the FAQ: http://msdn2.microsoft.com/en-us/xna/aa937793.aspx I think it's a significant possibility that Vista is the reason for the problem. Have you tested a release build as opposed to a debug ...Show All

• SQL Server Error while installing sql server 2005

  Need Help. I'm trying to install sql server 2005 on Windows server 2003 and got the following error message "The setup has encountered an unexpected error while setting up reporting service and share point exclusion path. The error is: Fatal error during installation." Not sure what to do next. Hi, see the screencast on my site how to configure a site-by-site installation with Reporting Services and Sharepoint HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Windows Forms WebBrowser stealing focus

  Hello, I would like to ask. I have WebBrowser component in my WinForms app (.NET 2.0). I display my own html pages without navigation. The WebBrowser intialization is: this .dataDisplayWebBrowser.Navigate( "about:blank" ); this .htmlDoc = dataDisplayWebBrowser.Document; this .htmlDoc.MouseDown += new HtmlElementEventHandler (htmlDoc_MouseDown); this .htmlDoc.MouseMove += new HtmlElementEventHandler (htmlDoc_MouseOver);   Displaying page: this .htmlDoc.Write(html); this .dataDisplayWebBrowser.Refresh();   Problem: When I click to the browser once time, it gets focus. It is OK, but after all new pages displaying, it gets the focus again without need to click. I want to prevent it, be ...Show All

• SQL Server Two Newbie Reports Questions

  Hi, I have a report with 3 parameters. One of which is Company name. To get the available list for this I use a query: select distinct name from companies, etc. However, I also want the user to be able to select "All" or an equivalent to get all the companies. I tried putting * and % in the default values (non-query), but the drop down list displays "<select a value>". Also I've enabled drill-down, is there a way to auto-expand the results Thanks, Dan Just worked it out, by clicking on the row, edit group, then setting the display setting to initially visible rather than hidden. ...Show All

• SQL Server Changing DB connection from SqlServer to Oracle

  Hi I am trying to switch between oracle and sqlserver databases to read the source data. I have used a parameter file to specify the connection parameters. For SQLserver the connection looks like in the file as below: < xml version="1.0" ><DTSConfiguration><DTSConfigurationHeading><DTSConfigurationFileInfo GeneratedBy="ab\vsh" GeneratedFromPackageName="Package" GeneratedFromPackageID="{8A304BF7-5325-4079-9D92-2B9BBF8793AA}" GeneratedDate="1/23/2007 4:46:08 PM"/></DTSConfigurationHeading><Configuration ConfiguredType="Property" Path="\Package.Connections[dl.PM_DW].Properties[ConnectionString]" ValueType="String"><Conf ...Show All