User Profile

Collapse

Profile Sidebar

Collapse
Wavey
Wavey
Last Activity: Sep 11 '09, 11:19 AM
Joined: Feb 19 '09
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Wavey
    replied to Query parameters doing something odd
    in C Sharp
    Hi,

    Thanks for the suggestion, however it didn't fix it when I changed my variable to a VarChar. i still get the same problem.
    Moving this to the C# forum is fine with me.
    See more | Go to post

      Leave a comment:

    • Wavey
      replied to DataTable row data merged when updating the database
      in .NET
      Hi All,

      Just a bit more information

      I write to the access database with the following code

      Code:
       
DataRow editRow1 = ds.Tables["TraderNames"].Rows.Find("1");
DataRow editRow2 = ds.Tables["TraderNames"].Rows.Find("2");
editRow2["TraderName"] = "Bob";
editRow1["TraderName"] = "AAAAAAA";

update.Parameters.Clear();
      ...
      See more | Go to post

        Leave a comment:

      • Wavey
        started a topic Query parameters doing something odd
        in C Sharp

        Query parameters doing something odd

        Hi All,

        I have a C# test app that writes to an access database with the following code

        Code:
         
DataRow editRow1 = ds.Tables["TraderNames"].Rows.Find("1");
DataRow editRow2 = ds.Tables["TraderNames"].Rows.Find("2");
editRow2["TraderName"] = "Bob";
editRow1["TraderName"] = "AAAAAAA";

update.Parameters.Clear();
        ...
        See more | Go to post
        • Wavey
          started a topic DataTable row data merged when updating the database
          in .NET

          DataTable row data merged when updating the database

          Hi All,

          I have a problem with updating an Access database from a datatable. I have two rows of data in my database at the moment for testing, the first row is an ID number (primary key), the second is a name and the third is a price.

          I can get this data out of the database, store it in a datatable in a dataset and display the name in a listbox with the name and price displayed in textboxes.

          If I change...
          See more | Go to post
          No activity results to display
          Show More
          Working...