I have the following subroutine to list the tables from a selected SQL Server database. In this case AdventureWorks. Private Sub DisplayDatabaseTbls(ByVal tblTables As DataTable) lstTbls.DataSource = Nothing lstTbls.Items.Clear() For Each row As DataRow In tblTables.Rows lstTbls.Sorted = True lstTbls.DataSource = tblTables lstTbls.ValueMember = "Table_Name" lstTbls.DisplayMember = "Table_Name" Next End Sub It retrieves the database tables just fine, but when I open up the same database in Microsoft SQL Server Management Studio Express I noticed that the tables where listed differently. Example: My Subroutine list the tables like this: AWBuildVersion Department Employee While SQl Server Management Studio list them like this: dbo.AWBuildVersion HumanResources.Department HumanResources.Employee Can someone tell me how I can make my subroutine match the SQL Server Management Studio? Thanks in advance, Quecumber256

Luc, That did it. All I did was place lstTbls.DataSource = Nothing at the top of the subroutine. So whenever I changed databases it will disconnect the datasource, then clear the list box, and reconnect the datasource and repopulate the listbox. Thanks this helped a bunch. Quecumber256

I have the following subroutine to load a listbox of database tables: Private Sub DisplayDatabaseTbls(ByVal tblTables As DataTable) lstTbls.Items.Clear() For Each row As DataRow In tblTables.Rows lstTbls.Sorted = True lstTbls.DataSource = tblTables lstTbls.ValueMember = "Table_Name" lstTbls.DisplayMember = "Table_Name" Next End Sub This works just fine until I deside to select a differnt database, then I get the error: Items collection cannot be modifed when the datasource property is set. I understand it will not let me repopulate the listbox while it is bound to a datasource. What I want to know is how I can disconnect the datasource, and clear the listbox. In VB6 all you had to do was Listbox1.Clear. Thanks is advance Quecumber256

Maximilien, Either they are "clueless" or greedy. Let us face a simple fact. My internet browser lets me block pop-ups and it is done using some type of software. It should be simple to block a piggybacked signal. If this keeps up I will start watching all my programs over the internet. This offers me two benefits: 1 - Limited commercials. 2 - No pop-up advertisements at the start or continuation of a program. Thanks for the reply, Quecumber256

Hello everyone: I am sure everyone has noticed whenever you are watching a program on the major TV networks after every commercial break when the program resumes they have another pop-up advertisement. These advertisements take up the bottom third of the screen. I find this annoying. I have just seen a commercial, now I want to see the program not another advertisement. Has anyone thought of making a software program that would block these stupid advertisements that come up during the first few seconds during the continuation or start of a program? I would happily pay for such an application for my cable box. I discussed this with my cable provider they said it is generated from the network nad they can't do anything about it. I think it is another signal piggybacked onto their primary one. I would think that this signal could easily be filter out. Thanks for letting me spout, Quecumber256

Hi Everyone: Recently while I've been trying to watch the TV, there are pop-up ads that cover up the bottom quarter of the screen that occur at regular intervals. This is especially annoying when the program contains subtitles. This occurs on every commercial TV network. Has anyone thought about making a device we can attach to our cable boxes that can filter out the pop ups? Since there is one for the internet I thought there might be one for cable TV. I wouldn't know where to begin. Thanks, Quecumber256

I was afraid of that.

Hi Dave, Thanks for the response. While I was waiting on an answer I continued to search the web and found the code using a Matrix to swap the y-axis to the bottom-left corner on the screen. Unfortunately, solving this problem lead directly into another. The new problem is: I'm playing around with a GDI+ application using VB.NET. I have written a small Windows application that will allow me to place a rectangle at the screen's origin (top-left corner of the screen). After the rectangle is placed I can point to it with my mouse and by holding down the left button move the selected rectangle elsewhere on the screen. This only works when the Y-Axis' location is at the top-left hand corner. I used a matrix transformation to reset the Y-Axis' origin to the bottom left hand corner. This time when I draw a rectangle it is placed at the bottom-left hand corner, but when I place my mouse on this rectangle it will not highlight saying this rectangle has been selected. The strange thing is: If I move the mouse back to the top-left corner where the default origin is the rectangle at the botton-left corner will highlight and when I press the left mouse button and move the mouse down the selected rectangle moves up. This is not how I want it to work. I have the project if you need it to see exactly want is happening. I wrote this for another discussion group, but I thought you would be interested in the problem that cropped up when I reset the origin to the bottom-left corner of the screen. Thanks, Quecumber256

Hi Everyone: I have two questions: 1. I saw a trick using the Matrix class that will shift the Y-axis origin (0,0) from the top left hand corner to the bottom left hand corner. Can anyone provide the code for this? I can’t remember where I first saw it. 2. After I reset the Origins I would like to draw a grid pattern on the form. I would like the grid pattern to be adjustable. Does anyone know where I can find an example of this for VB.NET? Thanks in advance, Quecumber256

I have the following code: int numAmt; string preFix; numAmt = 10; preFix = numAmt.ToString(); How come I can't convert the intger 10 to string '10' using the ToString function provided by the .NET framwork? Quecumber256

Yes I did, but I used 0.4155 because that was the number provided in the text. I bet the number you gave me was the most accurate one. Quecumber256

Thanks, this example helped me with my problem. Quecumber256

Iain, Thanks, but this gets away from my initial problem; defining the Planets class for use. Quecumber256

Rajesh, Thank you for the reply, but I'm still getting a problem. I'm trying to reprogram my brain to use OOP instead of procedural programming. The problem is simple in concept. Take a person's Earth weight and calcultate their weight on the other planets of our Solar system. The trick here is it has got to be done using classes and constructors. For example: MyWgh = Planets.Mercury(235.5) would give me their weight on the planet Mercury. According to the instructions the default constructor should return the weight enter for Earth. Can you help me grasp this concept? Quecumber256

Good morning, I need help in designing a class in C++. For experimental purposes I started with something simple. // Header File Planets.h Declares class Planets. class Planets { public: double Mercury; private: double weight; }; //Implementation file Planets.cpp implements the member //functions of Class Planets. #include "stdafx.h" #include "Planets.h" double Planets::Mercury // Pre: Earth weight. // Post: Earth weight times the gravitation constant // of Mercury - 0.4155. { return wgh * 0.4155; } // MT_Planets.cpp : main project file. #include "stdafx.h" #include <iostream> #include "Planets.h" using namespace std; int main() { double iWgh = 235.6; double MyWgh; MyWgh = Planets.Mercury(iWgh); cout << "My weight on Mercury is: " << MyWgh << endl; system("pause"); return 0; } When I try to compile the project I get the following error: Error 1 error C2063: 'Planets::Mercury' : not a function c:\Documents and Settings\Mark McCumber\My Documents\Visual Studio 2005\Projects\Visual C++\MT_Planets\MT_Planets\Planets.cpp 10 Can someone explain to me what I'm doing wrong? Quecumber256

Hi Dave: Thanks for the input. The experiment I'm running uses a 50 point font, which in turn produces an image large enough to know you are clicking on the character itself. The bitmap approch did occur to me as a possible solution, but considering the work involved producing 255 bitmaps, one for each ANSI character it didn't seem like it would be practical. Obviously there is a fundimental difference between shapes drawn using GDI+ and how GDI+ handles fonts. There has got to be some method out there that will allow me to capture the font, but so far my searches have produced ziltch. Quecumber256

Hello Everyone: I have an interesting problem. I modified a C# application written by Bob Powell that demonstrated how to move graphic primitives to Visual Basic 2005 .NET. I want to take this a step further and be able to move alphanumeric characters around on the screen using the mouse. My problem is I can draw a series of characters using the DrawPath method, but when I point to a specific character to hit test it the application’s HitTest Function does not recognize the character. I’m guessing the problem lies in the class I created for the text, but I don’t know how to solve the problem. I wrote to Bob Powell and he suggested using glyphs. I’m assuming he wanted me to take the fonts and convert them to glyphs. This is where I get confused; a font is just a glyph. It seems redundant to create a glyph out of a glyph. A single font character has a height and a width. The hit test function returns those values and uses them to create a rectangle around the graphic primitive I’m pointing too. Once the primitive is highlighted I can move it elsewhere on the screen by holding down the left mouse button and move the mouse to another position on the screen dragging the highlighted primitive with it. Does anyone have any ideas? Quecumber256

Does anyone know where I can find some sample code that demonstrates a screen capturing routine where the user goes to an area on the screen holds down the left mouse button, drags the mouse over the area they wish to capture and on the mouseup event saves the selected area into a bitmap file? Thanks, Quecumber256

Dave: Thank you. I have had some discussions with our .NET developer here at the office and he put some things in perspective for me. For example: I drew a square on the windows form. That would be level 1. Next I drew a circle on top of the square, this is level 2. So if I click on the circle I have to have some routine that looks at the levels and sees where the cursor is pointing, which level it is on, and then place some kind of "visual handlers" around the object then use another routine to move it on the form. This helps me grasp the concept of what I'm trying to accomplish. Do you have any recommendations for books that cover graphics manipulation and programming for VB .NET? Thank you, Quecumber256

Hi Everyone: I'm trying to teach myself VB 2005 .NET and the best way I have found to learn something is to make a project in the language I wish to learn. I'm playing with a graphics Windows application. I want to draw a simple graphics shape(rectangle, circle, line, etc) on a windows form and be able to move that graphics object anywhere on the form using the mouse. Does anyone have any sample code that can draw a shape on the windows form and allow to move it with the mouse, or arrow keys? Thanks in advance, Quecumber256