To start off their is no comparison :) Regards, Thomas Stockwell Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. Visit my homepage Oracle Studios Discounted or Free Software for Students: DreamSpark - downloads.channel8.msdn.com MSDN Academic Alliance - www.msdnaa.com

Read up on unique constraints. Generally your database shouldn't let you insert "bad" data, so you enforce this with constraints. Then your UI probably should deal with the situation nicely, either by checking first, or handling the exception that gets thrown when you try to insert the second row. Mark Churchill Director Dunn & Churchill Free Download: Diamond Binding: The simple, powerful, reliable, and effective data layer toolkit for Visual Studio.

You could use the Wizard control for that. Work @ Network integrated solutions | Flickr | A practical use of the MVC pattern

is NA an optional parameter in your proc ? What does 'not working' mean ? Does it blow up ? Does it give an unexpected result ? Does it never work out that checkbox1 is checked ? BTW, for you to put this code in your presentation layer is bad design. I guess the fact that you have a checkbox1 means this is not production code, but still, it's better to form good habits than bad. Christian Graus Please read this if you don't understand the answer I've given you "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

jds1207 wrote: When I do: DropDownList1.SelectedItem.Text = "" it will clear the selected item out of the display and the list. No, it will set the text of the selected item to an empty string. You can't clear the selection of a DropDownList, there is always one item selected. Set the SelectedIndex property to zero if you want to reset it back to have the first item selected. Despite everything, the person most likely to be fooling you next is yourself.

jds1207 wrote: how do you go about publishing your site with this tool? You cannot publish a website from Express Edition tools. They are just for learning purpose. If you still want to do that buy Professional or other Edition. jds1207 wrote: keep getting a Parser Error message: unrecognized attribute in my web.config file Post you web.config file Venkatesh Mookkan My: Website | Yahoo Group | Blog Spot

Chek this[^] I Love T-SQL "Don't torture yourself,let the life to do it for you."

Wow - you cross posted half the site. How annoying.... Christian Graus Please read this if you don't understand the answer I've given you "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

Thanks!

Learning asp.net is a breeze. Check this out: http://msconline.maconstate.edu/tutorials/aspnet20/default.htm[^] Vasudevan Deepak Kumar Personal Homepage Tech Gossips A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson

You could put an If..Else block around your call to Insert() that calls a method to check whether the current filename is present in tblExclude. Paul

jds1207 wrote: this is very helpful but it still does not solve the problem. Wanna bet?? The problem you're running into is that all of this code is attached to a button event handler. You have to break this code out so it's not dependant on the UI click events at all. The code needs to be refactored to seperate the functionality from that TextBox. The search function needs to be able to stand on its own and do it's job just by passing the extensions to a method to start the search. Once you seperate this search code from the UI, your problem is 95% solved. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007

Thanks, that worked great! jds1207

Hi, check it http://www.vbdotnetheaven.com/UploadFile/mahesh/ProgressBar04262005051817AM/ProgressBar.aspx[^] regards, koolprasad2003:) If the message is useful for U then please Rate This message... Be a good listener...Because Opprtunity knoughts softly...N-Joy

If you have an icon in your project, you can double click on it and Visual Studio will open an icon editor so you can make your own. Or you can search on-line to purchase or find some free icons to download. Simply include the icon you want in your project. Then go to your application's properties and select the icon. If you want the icon to appear on the upper left corner of the form, you have to select the form and change it's icon property to the icon of your choice. Hope this helps.

I simply copied over (in code) the start menu icon that ClickOnce (thanks Microsoft...) created. Just ask if you want help doing that.

Well, I know you can do that sort of thing in a Janus GridEX by using conditional formatting. Maybe you can tell it to hide rows. I believe there is a trial version on the web somewhere. It is possible you could mean columns, which is easy from a datatable in VB.NET. If you really need to, use some special conditional formatting code and move the rows you do not want to a separate table.

Have you tried inserting a value in the ItemID field? It is supposed to autonumber, but, from your comments, it doesn't appear to. For what its worth, I DETEST autonumber... it has and is causing me to get heartburn... rather than autonumber, use a transaction or something to get the last value used and increment it for your insert. Tim

The error is thrown simply because nowhere in your code do you actually connect to the database. jds1207 wrote: cmd.Connection = con You tell the DataAdapter to use this connection, but not to actually open it. If you want you can try to adapt this function to your needs: Public Function OpenConnection(ByVal conn As SqlConnection, Optional ByVal db As String = "") As Boolean Try If conn.State = ConnectionState.Closed Then conn.Open() If conn.State = ConnectionState.Broken Then conn.Close() conn.Open() If db <> "" Then conn.ChangeDatabase(db) End If If conn.State <> ConnectionState.Open Then OpenConnection = False Else OpenConnection = True Catch Ex As Exception MsgBox(Ex.Message & "happened in: public function OpenConnection") End Try End Function just call it before .Fill. Good luck, Johan My advice is free, and you may get what you paid for.

Perhaps the machine doesn't have the Paradox driver installed? A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007