Search results for query: *

query = "select item.instock from item where item.id=3" mADOConnect.Open("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=C:\pr\HQ.mdb") mRS.Open(query, mADOConnect, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic) That does work! I didn't even know that I could open...

In the mdb, the query returns only 1 row as expected but the same query from VB is returning all the records from that table to the mRS recordset. :confused: Although, I've found a way to solve this by putting an additional line (e.g. mRS.filter=criteria) in my code, I'm not very happy with...

Thanks giadich. I did try that (in ms access) and it works ok. Actually, I was wrong there! The mRS recordset is containing all the records not just the first one (id 1) or the required one (id 3) as if its not filtering the result according to the criteria. :confused: Don't have a clue whats...

Hi, I'm trying to retrieve data from ms access database. Here's the simple code Private mADOConnect As New ADODB.Connection() Private mRS As New ADODB.Recordset() mADOConnect.Open("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=C:\pr\HQ.mdb") mRS.Open("item", mADOConnect...

Hi again :) I guess I should explain the scenario a lil bit. I am talking about an vb application where two way synchronization occurs. For example, a store has a database of its stock. Then, A salesman goes out with his laptop and sales some goods. Goods are purchased at the office and...

Hi :) I've been looking for different data synchronization (in database) methods in both networked and non-networked environment for some time now...Also tried google without much success :( Much appreciate if someone could provide any source/s where I can get information about different data...

Thanks Mentlhard for your reply. P.S. While searching more info on sql express, I just came to know about DotNetFirebird (seems like an alternative to sql express and its open source). I am gonna look into it now. Thanks again :)

Hi :) I like to make small simple applications (VB.Net) for everyday use. So, far I've been only using MS Access because I heard that if I use anything other database like mySQL then its not possible to distribute the applications as one setup since mySQL will require a seperate setup and...

Thank you very much Stonkie for your reply. I've been looking for this for quite some time but nobody told me about this memo field. P.S. I've found out that memo field allows 65535 chars (though I need more space but for the time being much better then the text field :) ).

Hi everyone :) I am trying to create a small application where I can store interesting articles and later retrieve those by selecting the topic. But I can't figure out how to save large data in a database since ms access only allows a max of 255 characters per field. Can anyone please tell me...

I get it now. I didn't notice your example properly (Dim webService As New wsns.Service) and misread it :o Anyway thanks again. See you later :)

Thanks JohnH for your kind reply (as usual :) ) My application is working now. However, the code is a lil different and I'm not sure why that is. Below is the code - Dim ws As New localhost.Service() Dim p As localhost.Person 'Note that, I have to use localhost here not ws ...

Hello again :) I have a question which is supposed to be simple but I can't seem to get it right :( I have a web service (vb.net using visual studio 2005) with a method named getinfo(). I also created a class (Person) that has three attributes (fName, lName and DOB). Now, the method...

Hello again :) I was wondering how I can invoke different web services during runtime? For example, the client first contacts a web service (which is accessed through a design-time generated proxy) then the web method returns a URL for another webservice wsdl file as string. So, using this...

Interesting topic... I know the recommended naming convension for .NET. However, I prefer 'txtAnyDescription' over 'anydescriptionTextbox'. I agree ! It makes me code with ease. In my opinion, when I'm coding it has to be comfortable to me first! then think about other developers (although...

Thanks JohnH. I am glad to see that you are still around to help :) Well, first of all an apology :o . I guess its my imaginary scenario I described earlier is causing all the confusions. When I created the scenario in my previous posts, I knew very little about web services (I still don't know...

:s I am lost again !!! :( Someone has told me today that the way to discover webservices dynamically has to do something with UDDI and something called 'reflections' (but I didn't have a clue what he was talking about!)....:confused: I'm feeling very low at the moment... :( :( :(

Thank you very much jwh for your reply :) Glad to hear that it can be done. Could you please tell me (or post any links) how I can achieve this ? :o Edit : ok..I've done a quick google search and it seems there are a number of articles on how to create custom controls...so I'm gonna look at...

Hello :) Is it a good idea to declare variables right before using it or should we declare all variables at the beginning of the code (like in C) ? Whats the standard or good practise ? Thanks. Edit : Perhaps I should've put this question in the VB.NET section. (dunno what's happened to me...

Thanks JohnH for the clarification :)