Search results

  1. D

    Reading UTF from Access database

    Hi I have a php web site with a MySQL database and a table with a name column of collation 'utf8_unicode_ci'. Stored in this table is a name of gökçe When the php displays this name it shows as gökçe I download the mysql table to a local access database to do reporting from it. How do...
  2. D

    WebService errors

    Update. i havent managed to sort to access denied error yet but i have sorted the other two errors. System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.NullReferenceException: Object reference not set to an instance of an object. This was caused by...
  3. D

    WebService errors

    Hi Ive created the CDService webservice locally on the desktop. I can interrogate the methods in a browser and i see the XML results. I removed the existing web reference from my client app and added this desktop local as the web reference. The code no longer errors on the debug.txt line...
  4. D

    WebService errors

    Hi I have some errors with my code and Im sure they are to do with priviledges but i cant find any information out about them. I have 3 machines. a desktop, a laptop and a server desktop - runs visual studio 2005 for a vb.net app and a asp.net web service. The web service lives on the...
  5. D

    datatable.merge and rowstate

    erm interesting point. I would say as they are read from a db and not changed they would be 'unchanged' aswell. if i change them all to 'changed' would they 'merge' nicely with the existing records? for example some records might already be there, so i wont to overwrite, and some might be new...
  6. D

    datatable.merge and rowstate

    Hi I have 2 databases with the same structure. I have filled the 1st dt up with contents of the local db and the 2nd dt with content of the remote db. I have used dt1.merge(dt2) hoping that i would get a dt1 with all the changes and new rows from dt2 and i could do a da.update(dt1) to commit...
  7. D

    Using readxml when integer column is blank

    Hi I'm calling a php page on a server that returns an xml string containing the info I need from a MySQL database. The final column retireved is a SmallInt(6) column that has some <null> values in it. When the XML is returned to my VB.net project the xml looks like: <numcode></numcode>...
  8. D

    Print Crystal Report pages bottom first

    Hi I have a VB.NET 2005 application that prints invoices created using Crystal Reports on IntegratedLabels. The sticky bits are on the top of the invoice, but apparently the ink smears down the page when printed. Is there an easy way to print a report with the pages printing bottom first...
  9. D

    VB>NET app interfacing with WebSystem

    I changed the remote currency table to be a normal integer for the PK and the access db to be autonumber on the PK. In this instance this worked fine as the PK ids on the website were 1 to 10. In my next table i only have 1 record with id 200. This is because all the rest have been deleted...
  10. D

    VB>NET app interfacing with WebSystem

    Hi I've got a few problems concerning how to interface with a web side database that is currently maintained by a php web site. At the moment I am trying to maintain a table full of standing data from within my VB.NET app. I have downloaded all the remote currencies into my local db. The...
  11. D

    Problems with using typed dataset and Access 2000

    Look at this link: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=189482&SiteID=1&PageID=1 Here's what I did to make my code work: Add this into the dataset.vb class: Namespace dsDatasetTableAdapters Partial Public Class OrdersTableAdapter Public ReadOnly Property...
  12. D

    Problems with using typed dataset and Access 2000

    OK will Ive found this Microsoft article that seems to points me in the right direction http://msdn2.microsoft.com/en-us/library/ks9f57t0(VS.71).aspx ' Connection etc etc ' Fill the DataSet. Dim catDS As DataSet = New DataSet catDA.Fill(catDS, "Categories") ' Add a new...
  13. D

    Problems with using typed dataset and Access 2000

    The logic for me is the easy bit. Getting bloody ado.net to return the orderid to me is the confusing part. If that worked 100% I can do some proper testing as the code is written to do what i want.
  14. D

    Problems with using typed dataset and Access 2000

    I need: 2 datatables one datarelation between PK and FK pk is autoinc, FK is not insert the PK record db calcs new value value is retreived auto by ADO.NET (only works if db contains data as then fill will load) insert orderdetailsrecord. Then i need to Select all records(with specific...
  15. D

    Problems with using typed dataset and Access 2000

    When the db is empty the order datatable doesnt know what value to start the OrderId primary key as so it starts from 0. The access db however knows the next record is going to be 3021. Then I call the update on the orderdetails table using orderid = 0 and of course it fails. If the db has...
  16. D

    Problems with using typed dataset and Access 2000

    Looks like its connected to the reason this post was started in the first place. The Order database table and the datatable 'Order' have matching OrderId's. The Orderdetails database table uses an autonumber and is up in the thousands now, the OrderDetails datatable starts from 0. Bastard...
  17. D

    Problems with using typed dataset and Access 2000

    I hear what you are saying but I cant figure out why. The Orderdetails table has a primary key, OrderDetailsId (autonumber) column which I am not changing. Im changing the value of the OrderId which is to say im changing which Order row it relates to in the db. I can open access and change...
  18. D

    Problems with using typed dataset and Access 2000

    and why cant i do this? It errors saying the updated affected 0 records. ' Search for the OrderDetails records with OrderId Dim dr() As dsDataset.OrderDetailsRow = Me.dsDataset.OrderDetails.Select("OrderId = " & orderId) ' Is it found If dr.Length > 0 Then ' Update it...
  19. D

    Problems with using typed dataset and Access 2000

    Odd, it seems to only error when the database is empty. If it errors and I restart the app it works fine. If I empty the db and restart it errors.
  20. D

    Problems with using typed dataset and Access 2000

    i am "filling" the row with the values I need before updating the db. Nowt wrong with that !! :) Anyway.... Order.OrderId and OrderDetails.OrderDetailsId properties --------------------------- AllowDbNull: false AutoINcrement: True AutoIncrementSeed: 0 AutoIncrementStep : 1 MaxLength: - 1...
Top Bottom