Updating a Windows DataGrid - with a stored proc. which has multiple joins

  • Thread starter Thread starter Ken
  • Start date Start date
K

Ken

Hello Everyone,

I have a datagrid which is built based on a combobox.Text
input. The data is coming from a stored procedure which
has several joins ,to make the info more readable.
However, I am only interested in editing fields in the
table supplied by the combobox.Text.

From what I have read you can use the command builder --
ONLY-- if you are selecting from one table. Is that
correct?

Is there a way to tell .NET Framework which table is the
primary table and can be edited?

Thank You in advance for Your Help,
Ken
 
send data to the stored procedure(s) and update only those tables
(single/multiple) which you are intersted to update in. you can send
tablename as parameter into storedprocedure, and in storedprocedure you can
check which table you want to update, which are not.

commandbuilder doesn't help you in your case.

Rajesh Patel
 
Back
Top