AFAIK, this is not the correct way of doing it. You must know that onChange function of the Select box will be executed on the client side. You have written code that will be executed on the server, which is wrong. So what you could do is: onChange of combo box, write a javascript function which will post back the page to itself. Pass the selected id in the QueryString. Now check for the corresponding QueryString in the page. If value is not null, write the code to get values from database (which you have already written). The important thing here is you need to understand how Classic ASP works. Once you know that, it would be easy for you to write code using Classic ASP. Xandip wrote: NB: I'm a beginner I would suggest you to go for ASP.NET if you are starting with Classic ASP. It has a lot of advantages over Classic ASP. You can always Google for them. :rolleyes: ..Go Green..

If you create your own collection, would you put it there?

hi, thnx for the reply.. The name is Sandeep

thanks guys.. :) The name is Sandeep

As far as I know it's not possible in SQL Server 2008 either. Why not use temp table in the process, like: - create temp table as you want the table to be - set IDENTITY_INSERT ON - copy the data to temp table using INSERT INTO ... SELECT ... - set IDENTITY_INSERT OFF - drop the original table - rename the temp table to orginal table using sp_rename The need to optimize rises from a bad design. My articles[^]

Yes, my posted query displays the name of the table and all its constraints. but in sql server 2000. I see yr query and its of sql server 2005. anyways, now u got the solution. but its just for yr info.. :) Krishnraj

A form could have a couple combo boxes that users cannot change the values of and each contains 50 items. You could use datareaders to very rapidly fill the combos. You might have to fill a collection or list object of some kind, you could initially fill the data quickly with a data reader. You wouldn't want to use a data reader and between each read perform a ton of checks and toggling UI properties, etc because you're keeping the connection alive. You want to use data readers in operations were the reads are very quick and then close the connection. Any suggestions, ideas, or 'constructive criticism' are always welcome. "There's no such thing as a stupid question, only stupid people." - Mr. Garrison

See if this helps you:: http://en.allexperts.com/q/Visual-Basic-1048/OutLook-Express-Address-Book.htm

Xandip wrote: Indexes should be only used in tables used for data retrieval and not in tables where frequent INSERT & UPDATE take place. When an Index is created over a table, then there is no need for defining a PrimaryKey for that table. Indexes are best suited for Views. No. Indexes can be used in tables which perform frequent insert/update/deletes. They are used to speed up retrieval of information, so if you need to select information from these tables you should consider whether or not they should be used. A primary key is not intended to act as an index. Just because a primary key normally has an index associated with it does not mean that having an index on a table negates the need for a primary key. The PK is normally used to provide a mechanism to allow you to reference a row in another table. This is because the PK is unique, so it uniquely identifies a row. Indexes can be used in views (DB dependent), but they are not best suited for them. Please visit http://www.readytogiveup.com/ and do something special today. Deja View - the feeling that you've seen this post before.

Xandip wrote: I need to get the idle time of my mouse & keyboard, to execute a screensaver Why? The system already does this automatically. Xandip wrote: Is there any API which does this? No. Why not just write a screen saver and install it? The system will handle the rest. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007

Xandip wrote: I set the centerscreen property to 'CENTER' Is there any property called centerscreen? :confused: The property is StartPosition, and if you set it to centerscreen than you will always have your application started in center of screen, no matter the monitor type/size.

obviously u must be knowing dave... this is code is not for you. yeah by mistake i replied your post...

Where was his question? Upcoming events: * Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ... * Reading: Developer Day 5 Ready to Give up - Your help will be much appreciated. My website

In VB.Net, you can use perfmon.exe utility to get the number of expections. In VB 6, you would use the errors collection of ADODB connection object and get errors.count VB Prog

Hi Xandip, I hope the code is useful... Here is the API declaration : Private Declare Function GetWindowLong Lib "user32" Alias "GetWindowLongA" _ (ByVal hwnd As Long, ByVal nIndex As Long) As Long Private Declare Function SetLayeredWindowAttributes Lib "user32" _ (ByVal hwnd As Long, ByVal crey As Byte, ByVal bAlpha As Byte, ByVal dwFlags As Long) As Long Private Declare Function SetWindowLong Lib "user32" Alias "SetWindowLongA" _ (ByVal hwnd As Long, ByVal nIndex As Long, ByVal dwNewLong As Long) As Long Private Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long) Private Const GWL_EXSTYLE = (-20) Private Const LWA_ALPHA = &H2& Private Const WS_EX_LAYERED = &H80000 Here is the code where you should use : Private Sub Command2_Click() Dim fadeCtr As Integer Call SetWindowLong(Me.hwnd, GWL_EXSTYLE, GetWindowLong(Me.hwnd, GWL_EXSTYLE) Or WS_EX_LAYERED) For fadeCtr = 255 To 0 Step -1 Call SetLayeredWindowAttributes(Me.hwnd, 0, fadeCtr, LWA_ALPHA) DoEvents Call Sleep(5) Next End End Sub Please dont use this code in Unload event of form - as you observe, I had used DoEvents in the above function. If this is useful, reply me to answer again.

Xandip wrote: i want to go beyond that Then ask a question that makes this clear Xandip wrote: can you give me some articles about it google can. This site is bursting with them Xandip wrote: what is the advantage in using these type of controls..?? Encapsulation and code reuse. I can create a control and use it in many places. Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Get a faster disk Upcoming events: * Glasgow: SQL Server 2005 - XML and XML Query Plans, Mock Objects, SQL Server Reporting Services... Never write for other people. Write for yourself, because you have a passion for it. -- Marc Clifton My website

are you a malayalee, why are you bullying people:mad: Vilsad P P MCTS (Windows Applications) .Net 2.0