wjbjnr wrote: I just wanted to know how many different connections at a same time can be made from different computers? 64k. Or some number pretty close to that. There are gotchas for that. 1. They must exist at the same time. 2. The number can be smaller, quite a bit, if the clients are rapidly opening and closing connections. 3. The number can be smaller, specifically 5000, if you have not explicitly updated the MS Windows registry of the server box. This is the maximum and is impacted by 2 above as well. None of that has to do with the database and certainly not tables. It has to do with the IP address. So if you have a computer with more than one real IP Address then each is subject to the same restrictions. See the following http://msdn.microsoft.com/en-us/library/aa560610.aspx[^] Be very careful if you start messing with those values.

There is a class called MethodInfo where in you will get all the info of the methods in the object and i would suggest you to learn this from any forums because it would help you more to learn about it like we could only guide you how to do a particular thing it would be good for you to learn new things

You cannot add new classes to your project at run-time. You need to write a program that creates classes dynamically, for example using CodeDom[^] or Emit[^] APIs of .NET. CodeProject has examples of using both these sets of APIs[^].

You're welcome :) Glad it got solved. The need to optimize rises from a bad design.My articles[^]

It's good that you have excellent tools to administer the database but in order to use the tools correctly you must understand what happens "under the hood", so one of the "must have" books is: http://www.amazon.com/Introduction-Database-Systems-8th/dp/0321197844[^] Also see the section "Customers Who Bought This Item Also Bought..." The need to optimize rises from a bad design.My articles[^]

As already said, basics of SQL should be learned first. But when you start to go deeper, have a look at these excellent books: Amazon's Complete Selection of Joe Celko Books[^] The need to optimize rises from a bad design.My articles[^]

Good luck! (It won't be that bad, honest!) Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together. Digital man: "You are, in short, an idiot with the IQ of an ant and the intellectual capacity of a hose pipe."

@Dave Kreskowiak yes i was reffering to ado.net.. Sorry for replying late (very late :)) So can the database be operated by ado.net?? @DaveyM69 DULY NOTED!!:)

ohhh rite!!!!!!! My God i'm literally blind at the moment.....!!!! such a small error!!!!! and the else was there in the for bracket!!!!...(no wonder why it was saying unreachable); so it only see's the exits!!!!!!!!!!!!!!!!hmmmmmmmm..!!!! now i finally understnd!!! @som shekhar ya i tuk a 1 hour rest..............it paid off!!!!! thnx all for your support!!!!!!!