WebService and Dataset
-
Hi, I've created a little webservice. I want to query, update and delete datas from 2 tables So I've created a SQLConnection and a SQLDataAdapter. The problem is with the SQLDataAdapter. I don't know how to tell .Net that the 2 tables are linked and must work togheter. I've tried to made this with the "Configure Data Adapter Wizard" but it doesn't work. Any1 know good idea to help me ? regards Sybux
-
Hi, I've created a little webservice. I want to query, update and delete datas from 2 tables So I've created a SQLConnection and a SQLDataAdapter. The problem is with the SQLDataAdapter. I don't know how to tell .Net that the 2 tables are linked and must work togheter. I've tried to made this with the "Configure Data Adapter Wizard" but it doesn't work. Any1 know good idea to help me ? regards Sybux
Hi , If you want to link 2 tables you can use dataset for that. In the dataset itself you will have to define that relationship . something like this custDS.Relations.Add("CustOrders", custDS.Tables["Customers"].Columns["CustID"], custDS.Tables["Orders"].Columns["CustID"]); I hope you are asking about this only. thanks