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

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

Rajesh
Fri Oct 24 12:14:19 CDT 2003

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


"Ken" <kkoski1@mindspring.com> wrote in message
news:0c8901c39a4b$f1035ce0$a501280a@phx.gbl...
> 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