do u want the number of records the query fetches. If yes, prepare the sql string like the one below Selcet Count(1) as RecordNum, col2, col3.... from table_name; here "Count(1) as RecordNum" will give you the number of rows. Regards, Jay

Some comments: 1. All too often you don't want to try/catch - a program should have way more try/finally than try/catch. If you're accessing myCommand after the catch ((System.Exception e) {}, myCommand may have not been initialized due to an exception, as you're "swallowing" exceptions on the catch. Notice that if you add a "throw;" statement to your catch, the error message goes away. Be aware that "swallowing" exceptions is a bad practice and leads to code that's hard to debug and problems hard to detect, as the problem will never happen near the real error. 2. If this doesn't solve, you can substitute SqlCommand myCommand; for SqlCommand myCommand = null; Again, use this wisely, as you can hide exceptions and introduce subtle bugs... Yes, even I am blogging now!

try assigning the command a null value : SqlCommand myCommand = null; I hope you understand... By the way... visit http://nehe.gamedev.net[^]

You could just create a user control for each "page" that you want to display. Or you can use something like Al Gardner's Wizard Control -Matt ------------------------------------------ The 3 great virtues of a programmer: Laziness, Impatience, and Hubris. --Larry Wall