:laugh: A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007

Check out this Ultimate Testing Checklist: http://www.sitepoint.com/article/ultimate-testing-checklist[^] Vasudevan Deepak Kumar Personal Homepage Tech Gossips

Syntax to DROP a column: ALTER TABLE table_name DROP COLUMN column_name No,U can DROP the Column even if it contains data also. Cheers Chandu

Good !!!! :rose: Pavan Pareta

The example query I gave works fine for SQL Server 2005 @FirstRow = row, from which you want to start getting the results @EndRow = last row of your results In your case, for exapmple, it can be SELECT OrderID,ItmDesired FROM ORDERS WHERE OrderID BETWEEN 5 AND 25 OR, if this does not work, in your db, try: SELECT OrderID,ItmDesired FROM ORDERS WHERE OrderID > 5 AND ORDERID < 25 Sincerely, Elina Life is great!!! Enjoy every moment of it! :-O

Nothing is working. My db name is siebeldb and presently there is only 1 table in it, namely 'orders'. But knowing that siebeldb is the database, how do I get the names of the tables it contains. Also when I know a table, how do I get the fieldnames and fieldtypes in the table.

DTDs and XSDs (Xml Schema) are files that specify the allowable structure of XML files. They define the entities and relationships represented in XML files. So that you can validate XML against them to know that your XML conforms to the rules of the DTD/XSD. DTDs are the old standard for doing this. XSDs are the new standard. Google XSD and you'll find lots of references. If you don't really want to learn XSD right this minute, or you just need an XSD spec immediately, there are tools out there that can help. XMLSpy will generate an XSD from XML if you have sack loads of cash. Skeleton Crew[^] can also produce an XSD for you. Just drop in some XML that has all your possible nodes/attributes, set your renderer to XSD, and build. The XSD that's generated will likey need a little work (changing the optional/required attributes where appropriate), but it will give you a good starting schema. But like I said, google XSD, W3 Schools has a good XSD reference to help you finish your spec out. Hope that helps. Try code model generation tools at BoneSoft.com.

Please don't cross post. Pick an appropriate forum and ask the question there. Deja View - the feeling that you've seen this post before.

ArchaBhandare wrote: I heard from some of my friends that some sites like 'geocities' or something allow free uploading. Yes Vasudevan Deepak Kumar Personal Homepage Tech Gossips

I dont' believe you can simply by setting a property. You can extend the checkbox by creating a class and inheriting the checkbox. In the OnPaint event you could fill that square in yourself with a different color. However, you'll have to draw the check mark as well.

Hi, You can try: tabcontrol.TabPages(0).BackColor = somecolor My advice is free, and you may get what you paid for.

Thanx for your reply. I got it working. This is a client side implementation. The client receives an url to an xml file in the response and wants to save the xml file. The changes I had to go were as follows Say for instance, the server return in its response, an url to an xml file, urlPath = "http://abc.xyz.com/tmp/ordera5fgscfs122dfbvgefsdsd.xml" I want that when the client receives the url to an xml string in the response it saves the xml file as follows, filePath = "C:\saved.xml" Now I am using the following code: Dim xmlDocToSave As New DOMDocument40 xmlDocToSave.Load (urlPath) xmlDocToSave.save (filePath) This will save the contents of the xml in 'saved.xml' in C:\

Thanks, it worked

Heah thanx, I got the thing working with the following piece of code Dim folderPath As String Dim fs folderPath = "C:\test" Set fs = CreateObject("Scripting.FileSystemObject") If (fs.folderexists(folderPath) <> True) Then MsgBox "Folder does not Exist" Else MsgBox "Folder Exists" End If

There is no FolderBrowserDialog in VB6. You have to make your own from scratch. It's a bad idea to look at C# or VB.NET code and try to convert it to VB6. There is SO MUCH that the .NET Framework supplies, like the FolderBrowserDialog class, that you have to recreate from scratch that it makes using VB6 nearly impossible because of the time you'll waste reinventing everything you see C# and VB.NET using in the .NET Base Class Library. Dave Kreskowiak Microsoft MVP - Visual Basic

The Exception message is as follows "An unhandled exception of the type 'System.MissingMethodException' occurred in System.Windows.Forms.dll" I tried replacing the dll file, but it still crashes at 'this.Close()'. I have upgraded by device. Still the issue occurs. The best thing is that it works for all other forms, only for this particular form, the 'this.Close()' gives an exception. If I comment out this line of code and have a this.Dispose() instead, the application does to crash but closes automatically at some other point.