Recent content by ProgMan

  1. P

    Whats wrong with retrieve data?

    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...
  2. P

    Whats wrong with retrieve data?

    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...
  3. P

    Whats wrong with retrieve data?

    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...
  4. P

    Whats wrong with retrieve data?

    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...
  5. P

    Can't find Data Synchronization methods

    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...
  6. P

    Can't find Data Synchronization methods

    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...
  7. P

    Which database is suitable for small DISTRIBUTABLE applications?

    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 :)
  8. P

    Which database is suitable for small DISTRIBUTABLE applications?

    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...
  9. P

    How to store large data in a database?

    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 :) ).
  10. P

    How to store large data in a database?

    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...
  11. P

    How to return a custom object to the client application?

    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 :)
  12. P

    How to return a custom object to the client application?

    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 ...
  13. P

    How to return a custom object to the client application?

    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...
  14. P

    How to access DIFFERENT web services at RUNTIME?

    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...
  15. P

    Naming conventions!

    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...
Top Bottom