Thanks for the response. Ya using ref in the method's declaration of C# we can get the correct syntax in VB but is there any other way which does not require any ref in the method declaration.

You can execute a sql statement: select databasepropertyex('', 'Updateability'); return false means read-only

so there is some xml data with 0, 1 or more occurances of "title" anywhere? okay..but what do you expect your query to return?

Thanks for the reply, Exactly i am using access. Actually my code calls internally some services which are also using the same connection and upto my knowledge they are getting closed as soon as the service use is finished. Or otherwise is there any way to view all the connections which are open?

I don't think there's anything built in, so you'd probably have to iterate through the entire collection and keep a count yourself. "On one of my cards it said I had to find temperatures lower than -8. The numbers I uncovered were -6 and -7 so I thought I had won, and so did the woman in the shop. But when she scanned the card the machine said I hadn't. "I phoned Camelot and they fobbed me off with some story that -6 is higher - not lower - than -8 but I'm not having it." -Tina Farrell, a 23 year old thicky from Levenshulme, Manchester.

Ya thats a very good alternative thanks for it. But still is there any way to get it with the Xpath as the parameter? Because my xml file contain multiple occurrances of some nodes and with in those nodes some Hierarchy levels are there so to extract them, if i use XPath mechanism then the nodes will come properly.

I never bothered to figure that one out. I'm guessing that since you can't do it in VA code in Access either that the "problem" would be tied to Jet, but I could be wrong. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007

The order of parameters should not be an issue. You need to first check your update stored procedures or statements. The easiest way to do this is to trying and execute them (using EXEC) directly in the database. This will enable you confirm whether they are OK.

What you are looking for is known as XML comments. They provide a lot of documentation possibilities for you code. You can look on MSDN or Google for "Xml comments" and find a lot of information about them. The Description attribute is a runtime concept and doesn't have any affect on the Visual Studio IDE. Scott. —In just two days, tomorrow will be yesterday. [Forum Guidelines] [Articles] [Blog]

nicolus wrote: //below statement returning number instead of string objImpRecService.ImportStandard = ImportStandard; Of course it returns a number. Change it to: objImpRecService.ImportStandard = ImportStandard**.ToString()**; Greetings - Gajatko Portable.NET is part of DotGNU, a project to build a complete Free Software replacement for .NET - a system that truly belongs to the developers.

I'm not sure. But I don't see the point of having a xls schema to help you form your xml correctly, if you don't follow the schema. :) Then you might aswell remove it. -Larantz- for those about to code, we salute you http://www.itverket.no Please refer to the Forum Guidelines for appropriate posting.

You can create a class by inheriting the Connection class. Thanks and Regards, Michael Sync ( Blog: http://michaelsync.net) If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message". Why vote? Plz Read it here. Thank you. :)

I was thinking he was messing out on something on a DAL factory front and not properly using the IDBConnection. Vasudevan Deepak Kumar Personal Homepage Tech Gossips

Shared configuration file? -^-^-^-^-^- no risk no funk ................... please vote ------>

The one time I saw this happen, I found that I had inadvertantly wired my click handler event in twice. First in InitializeComponents() and later in another piece of my code.