Manipulate Table Data...?

Question

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

naura pax · Answer

Dear Flamur, You'll realy have to give your table structures. And I hope you have kept some reference of product (or order) in your Furnishing table. If you that you would know exactly which row to update. Quote: If you know which row exactly you want to update, that can be accesed by your primary key.. combination of columns that give a unique row. And you know which columns to update (say qty) you can easily get a cell- Cell = [RowIndex][ColumnIndex]. Don't make your application unnecessarily complex just think of simple terms. Thanks and Regards

Flamur Hadja · Answer

Thnx again for the reply ... Exatcly, ur method didnt work couse what i need Is something else.. Since it seems that u didnt understand my question I will try to clarify it.. I want to have a table where the user can register products and stuff like that... I've already created this table and made a form for that... Now, I will create 2 more forms, a form from where the user can sell the products, and a form from where the user can keep track about the number of products he bought for his store and the date... Now I want to use the tblRegister table as a base from where the info about products will be taken... For example... When the user buy some stocks, he will need to keep track about that, so he can make reports about how much products did he buy in a month or something... so, for this he will use the form for Furnishing, and in that form i want to be a Text Box where the user can enter the product barcode and another Text Box where the user will enter the Quantity, so when he click Add i want to search in tblRegiser find the product using the entered barcode and take the info for that product from that row, and add them to the Furnishing table... for example... the name from a cell in tblRegister will be taken from there and will be inserted to the Furnishing table, the price will be taken from there and will be registered to the Furnishing table... etc... And the quantity will be taken from the text box, and the date will be added automatically in a cell to the Furnishing table... The problem is how to take a specificcell from the tblRegister and add it to a specific cell in the Furnishing Table, and how to take the quantity from the text box and add it to a specific cell in Furnishing table and to add all this info as a new row in Furnishing table... What should I use for this ... How to do it... should I write a query or Stored Procedure in SQL, or can I do this using C# codes that manipulate with datas like Data Binding, ADO.net, LINQ, or something,,,, It will be really good if some1 just tell me what I should use to build my App, to give me some ideas couse im really confuse... IF my question isnt still clear please let me know, I will then send the tables and some other pics couse I reeally need to solve this... thnx a lot...

Flamur Hadja · Answer

Yeah I think thats exatly what I need... I dont know if this form works couse I connected the database using the Wizard, but ill try it... and also what I need is to find the row I need using the Where function or somthing... however... ill give it a try after my holydays... thnx a lot for ur reply.. couse I couldnt have answer from any forum till now... thnx again...

naura pax · Answer

Hi there, sorry just couldn't download your image coz firewall won't let me. I assume you have two datatables furnishing and other. and you want to copy value of cell from one to another. I am thinking at very simple terms so please correct me- DataTable2.BeginEdit(); DataTable2.Row[YourRowNumber]["YourColumnName"]= DataTable1.Row[YourRowNumber]["YourColumnName"]; DataTable2.EndEdit(); This is how you can set the cells of the datatables you are using as datasource directly. Please tell me if I have understood it right and that's what you need.

Flamur Hadja · Answer

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

Flamur Hadja · Answer

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 ... [URL=http://img269.imageshack.us/i/furnishing.jpg/][IMG]http://img269.imageshack.us/img269/4747/furnishing.th.jpg[/IMG][/URL] 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

Manipulate Table Data...?

Rashid Khan

Suthish Nair

Krishna Garad