Manipulate Table Data...?
CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 3 of 3

Thread: Manipulate Table Data...?

  1. #1
    Join Date
    May 2009
    Posts
    10

    Manipulate Table Data...?

    Hi

    Im learning C# lately. Im working right now on a project that should help me learn some new stuff about C# programming...

    I'm programming a simple accounting software, that can be used by small businesses, especially by small shops. This software should register products, it will have a form to sell them and pay bills, a form to use for furnishing, and will also make reports and such stuff...

    I made the register form, but now I'm having some problems with furnishing form.
    For example, when the store owner buy some products (furnish his store with products) I want to register them on furnishing form, but he will be able to register these products only if they're registered first in the Registering Form... In the furnishing form he will only need to enter the product Barcode and the Quantity, and these automatically will be added to the database (furnishing table) and the other details for the product will be taken from the other table (registering table)...

    I usually use LINQ's to take a row from a table, for example, a row where given barcode match, but i dont know how to take a specific cell from that row, and send (or add) the data to another cell on another table...

    Hope u can understand what im asking ... Im sorry for my bad English...

    Hope ill find some help too..

    thnx a lot...

  2. #2
    Join Date
    May 2009
    Posts
    10

    Re: Manipulate Table Data...?

    Since I have no reply on my question, I though maybe it will be better if I make the question simpler and more detailed...

    OK.. here is an image how the Furnishing form will be ...




    Since the names are not in English, i wrote a translate for some important Columns.

    The DataGrid that ur seeing is connected with Furnishing table, and will show records from that table...

    I want that the user to enter a barcode in the textbox, and the quantity for that product and then when he click add, the Registering Table (the table where products are registered) will be checked, if there is a Barcode Match, the product details from the register table will be taken and will be insterted to specifik columns on Furnishing table, the quantity that is entered on textbox will be insterted at the Quantity column on the Furnishing table... and the columns Date will be the actual date...

    I just have no idea how to do this right now...

    Hope ill get some help now...

    or maybe u just can tell me what to use to accomplish this, should I do this using LINQs, or ADO.net, if someone can refer me a book or tutorials it will be really cool...

    thnx a lot
    Last edited by BlackIP; July 13th, 2009 at 07:05 PM.

  3. #3
    Join Date
    May 2009
    Posts
    10

    Re: Manipulate Table Data...?

    come on... does any1 know how to take a cell in a table and put it to another table..

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Windows Mobile Development Center


Click Here to Expand Forum to Full Width

This is a CodeGuru survey question.


Featured


HTML5 Development Center