Mahdi_kishislan wrote: is it possible Yes. Anything else I can help you with? Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]

No, it is not a good idea - it is a very bad idea. Remember your OOPs concepts - this breaks them (pretty much all of them) and makes future development and maintenance much harder. Just because you can do something, doesn't mean you should. This message is manufactured from fully recyclable noughts and ones. To recycle this message, please separate into two tidy piles, and take them to your nearest local recycling centre. Please note that in some areas noughts are always replaced with zeros by law, and many facilities cannot recycle zeroes - in this case, please bury them in your back garden and water frequently.

I Think You Should Add One More Column To Your Main Table As Type Now Your Table Structure Is (Code,Name,ID,Type) Now In Type Column You Can Insert Feeling Or Zone. And Now One One Insert Update And Delete Procedure Can Do The Same, As You Required. ------------------------------------------------------------------- Another Approach You Should Pass Table Name To Your Procedure And Create Dynamic Query. To Execute That Dynamic Query Use SP_ExecuteSQL Hope This Will Help You.......

HA! Well no I didn't look at the date. Doh! Just looking to do some give back. Thanks JD http://www.seitmc.com/seitmcWP

Please find this example. write the select query what ever the colums you want to display in datagridview http://www.dotnetsharepoint.com/2013/07/display-data-in-datagridview-c.html#.UfEm342fjwg[^]

what is the object you are referring to. Is it a dataset? Jack Sparrow -------------------------------------- Defeat is not the worst of failures. Not to have tried is the true failure.

here were to start Code Project[^] MSDN [^] :) Have Fun Never forget it

Mani_Kish wrote: want to encrypt password that user input from c# app how can do it There's numerous ways to do this. Look into the Cryptography namespace in .NET. "I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon

mahdimoola, My friends Larry and Sergey have a good website, its called google.com Regards, Gareth.