Thanks I'll give that a try.

- Aaron

During shutdown if this dialog comes up is there anyway to tell what program it's actually referencing? All the title says is "End Program - Available Networks". I'm sure this has something to do with my wireless adapter, but I've no idea what program it's actually referring to. Is there anyway to get this information?

- Aaron

Does anyone know if it's possible to remap the home folder to a different locatoin? When I was using XP I had My Documents mapped to my E drive so if I formatted I wouldn't have to backup the files and my E drive is much larger than my C drive. I see that I can still remap the documents folder, but since that isn't really the root "home" folder anymore it's not as convenient. Any help on this would be appreciated. Thanks

- Aaron

That code works because your Cheat class inherited from the TreeNode, which is exactly what you were casting it to and from. A TreeNode has no relation to a Row

- Aaron

Thanks very much for the information.

- Aaron

Two Questions: 1.) Does the image that you set the wallpaper to have to be a bitmap? I know that in the Display Properties you can select a number of different image types, but does Windows convert them to bitmaps before it sets the wallpaper? I ask because if I use a bitmap as the wallpaper I can change it fine, if I use a jpeg it doesn't work (just sets it to a gray background). 2.) Is there a more .NET'ish was to set the desktop wallpaper? I'm currently using P/Invoke with SystemParametersInfo to change it. I guess that's three questions...Any help on this would be appreciated. Thanks

- Aaron

This is exactly what I'm looking for, thanks very much for the help. It makes a lot of sense, but it's not something I would have thought of. Thanks again!

- Aaron

I'm designing a database (at which I do not have much knowledge) and I have a question. I want to have a table that has properties, such as title, author, length, etc for books and one of the properties I want is genre (fiction, non-fiction, thriller, etc). Here's my problem, each book could be have than one category so how would I set that up? I want to have the Books table with a Genre field which would be a FK to the Genre table. What I'm not sure about is storing the values because of normalization ie. if I just stored the GenreID's as a comma seperated list in the Genre field wouldn't that break normalization not to mention make it harder to parse...I'm just a little confused with how to design this and any help would be appreciated. Thanks.

- Aaron

According to the SQL Server 2005 BOL the image datatype is going to be removed in future versions of SQL Server, which is why I in the database I set the field type to varbinary(max), which indicates maximum storage is 2^31-1 bytes. The same problem still occurs in the program if I run it using

param_arr2[7] = new SqlParameter ("@jacket", SqlDbType.VarBinary);

I still get the same exception "Parameterized Query ... expects parameter @jacket, which was not supplied." Is there any way to set this up to have to parameter use as much space as is necessary to store the image? Thanks for the help.

- Aaron

Sure. This is basically what my T-SQL looks like:

SELECT * FROM dbo.Books
WHERE title LIKE '%search%' OR author LIKE '%search%'

What I want to do is be able to pass in "search" as a parameter. I'm not sure how to do this though because if I remove the quotes around the search sting and add the @ in front of it, I get a syntax error. I hope that's clearer. Thanks again for the help.

- Aaron

I'm doing a program to try to learn some ADO.NET programming and I'm running into the following problem: One of the fields in my database is a VarBinary(MAX) that I want to store and image in. I created my own SqlDataAdapter to talk to the DataSet and such, now on the SqlDataAdapter for the InsertCommand and UpdateCommand I have the following parameter to correspond to the image field in the database:

param_arr2[7] = new SqlParameter ("@jacket", SqlDbType.Image, 15000, "jacket");

the problem is that I don't know how big the image is going to be so I don't want to have to specify the size in the parameter, and if I change the parameter to

param_arr2[7] = new SqlParameter ("@jacket", SqlDbType.Image);

when I try to update the data I get and exception with the message "Parameterized Query ... expects parameter @jacket, which was not supplied." Any help on this problem would be most appreciated. Thanks!

- Aaron

That seems to work quite well. Wondering if you could help with another question...how would I make the search string dynamic, as in I want to be able to pass in the value as a paramter...can I do this, if so what's the syntax? Thanks very much for the help.

- Aaron

I'm wondering if someone could help me with the SQL I'd need to accomplish the following: I have a db with a number of text fields and what I want to do is have a search box in my program that will search all fields for the text entered. For example I have first_name, last_name, alias, etc. and let's say I enter "Jim" in the search field. I want to be able to search all the fields (first_name, last_name, etc) for that term. Is this possible? I'd also like to use the LIKE operator so the text doesn't have to be exact. Thanks!

- Aaron

I saw a video at one point where the author added a search to a toolbar using the Windows Forms designer, but I don't remember where I saw it. Anyways, does anyone know a way to add a database search to the toolbar through the designer? The video author had a dataset (and all the other controls, binding navigator, binding source, and table adapter) all setup on the designer. Any help is much appreciated. Thanks!

- Aaron

Is it possible to use .ico files for the Image property of ToolbarItems, Buttons, etc? If so how? If not does anyone know a good program I could use to convert .ico's to a bmp, jpg, etc? Thanks!

- Aaron

Sorry about the late reply, but I haven't been near my computer for some time. Anyways, your answer worked perfectly so thank you very much.

- Aaron

I'm new to ADO.NET so if this question is odd, forgive me. Anyways, here the problem. I have a DataSet, that I populated with a SqlDataAdapter that I made, then I binded the DataSet to a BindingSource and hooked that up to some controls on my Form. Now if I want to add a new record to the DataSet table (there's only one in it) do I do it through the BindingSource or through the DataSet? And once the new row is added will the BindingSource be able to see it right away (so the Form can display the new record) or do I have to something to update the BindingSource? If a quick example could be provided as well that would be awesome. Thanks for any and all help.

- Aaron

That seems to have worked perfectly. Thanks very much for the help.

- Aaron

I've got a project going here where I created my own SqlDataAdapter. The problem I'm running into is this...the SelectCommand for the adapter requires a parameter (ie. WHERE id = @id), but I have no idea how to supply this parameter to the Fill method of the adapter. Any help on this is much apprecitated, and if you need any more info just let me know. Thanks!

- Aaron

Does anyone know what font the links (www.mpaa.org, www.filmratings.com, etc) at the bottom of http://www.apple.com/trailers/fox/x3/[^] are written in? I was going to check the page source, but the links are just images so I can't tell. - Aaron