DataGridView with multiple tables[Show/Insert/Update/Delete]

Question

Hello,

I'm using VS2008 [C#]

DB - Oracle11G

I have a database with two tables.Namely Emp_Master and Emp_Details.

How to show these two table[some columns] data in the datagridview and

insert/update/delete should be affected in both tables Emp_Master and Emp_Details.

Could someone tell me how to code this?

Thanks in advance.

thendral

thenndral · Answer

Hi, Thanks for your reply. I write code for using one table.Fill data with Dataadaper save data using update[this.adapter.Update(changes, "TEST");] please see my code. In the same way, i want to fill 2 table data and save/update/delete. please guide me. thanks in advance, thenndral

Sam Hobbs · Answer

Thank you for the clarification. Is your D ataGridView bound to the data or are you filling the control using code that you wrote? The solution depends on the answer. If I give you an answer but it is not for the way that you are doing things, then it would be a waste of your time and my time. Are you using the Entity Framework or a TableAdapter or a SqlDataAdapter or what? A simplified answer is that you simply need to create an update SQL command.

thenndral · Answer

Hi Sam Hobbs, Thanks for your reply.... Actually I know how to join two or more tables...But I don't how to implement in c#... I can show 2 table data in grid. i want to know how to update and delete from grid. if i update or delete data, it should be affected in both tables. so please give me such code or idea... Thanks in advance, thenndral.

Sam Hobbs · Answer

You need to learn SQL, especially about how to join tables. There are many articles in this web site that can help. There are many ways to do what you need to do and the solution you choose depends on many things. It will really help if you can first learn more about database programming so you can ask more specific questions and get more specific answers.