Search results for query: *

In building a simple C# application, I used the built-in tools on the DataSources tab to build a DataSet. We have three SQL Servers... development, model, and production. I was wondering if it's possible to use the same DataSet, but just change the connection string, depending on which SQL...

I'm a relative newbie to the wonderful world of SQL Server 2005. I have several small databases on my server (nothing very important). The other day I detached a database and then when I tried to log in again I got a "Cannot connect to ..." message. I asked a colleague about it, and he said...

My company has an Access database in 2000 format. We're coming up with some errors when running on a machine with Access 2003 installed. The scenario in question is a form with a subform on it. I discovered that, when stepping through the code on a machine with Access 2000 installed, the...

At work, I use the Print Screen feature on my computer (WinXP Pro SP1) all the time. It creates a .bmp formatted image. I them convert the image in Paint to .jpg format for my e-mails. I've never really questioned that things could be different until yesterday I had occasion to e-mail a...

I am creating a user control containing a ListBox and a Button. I am exposing to the user the Items property along with most of the other functionality of the ListBox. I was hoping that there would be an event that would notify you when the contents of the ListBox had been changed, but did not...

I have created a user control with two or more constituent controls on it. Can anyone tell me what is the easiest way to allow certain properties, events, and methods from each of the controls to be "visible" to the user, but not other properties, events and methods? Thanks, wcprog

I inherited some legacy code that I'm trying to refactor. I found this SQL statement, and for the life of me can't figure out what it does: ALTER TABLE [Location] ALTER COLUMN [Location_Address] SET DEFAULT Now I know what it should do if there were a value of some sort after the SET...

I have been trying to figure out how to copy a table from one Access database to another in code leaving its entire structure (minus relationships) intact. I tried using the SQL statement SELECT * INTO TableName FROM source but this only copies the basic data structure (datatype and field...

I have been trying to figure out how to copy a table from one Access database to another in code leaving its entire structure (minus relationships) intact. I tried using the SQL statement SELECT * INTO TableName FROM source but this only copies the basic data structure (datatype and field...

Here's my situation: I have a Frame inside of a PictureBox with vertical and horizontal scroll bars for scrolling the Frame. Inside the Frame I have about a zillion controls (I didn't design it, but unfortunately I have to maintain it) organized into sections (using other Frames). It has...

I know the subject of multiple columns has been discussed many times in this forum. However, my question is somewhat different than those I have found in searching through the discussions. I succeeded in formatting my data into 2 columns in my subreport, but it takes up the entire page. If I...

Say I have a table that looks something like the following: State Value ----- ----- FL 1 FL 5 FL 9 AR 2 AR 5 MI 7 MI 8 XX 1 XX 5 I use an SQL query to retrieve the records for a given state. If the state...

In one of my apps, I'm creating an array of "Yes/No" option buttons. Normally I use Frames to group my option buttons, but in this case a PictureBox is easier to line up graphically the way I need it. Does anyone know if I'm taking any kind of significant performance hit by using...

I post wildlife photos on my website using the Photo Gallery feature. I want people to be able to view them, but not copy them. Does anyone know of any method(s) that I can use to prevent, or at least make it difficult for a user to copy the photos? Thank you.

Aside from the more obvious advantages of saving typing and easier reading, does anybody know if there are any performance advantages to using the With... End With statements?

I'm using VB6 and am trying to convert a distributed database programmatically. Does anybody know of any way using ADO or SQL that I can set or remove a field's default value. Thank you.