I am using vs2005 to desginer a tableadapter.

I have modify the update command in the desginer, but the update command is
not identical between the desginer.

For example:

The original update command is:

Update Employee set EmployeeID=@EmployeeID and EmployeeName=@EmployeeName
where EmployeeID=@Original_EmployeeID and
EmployeeName=@Original_EmployeeName

I change it in the designer to

Update Employee set EmployeeName=@EmployeeName where
EmployeeID=@Orginal_EmployeeID, and the count of parameter is 2.

But the commandtext in deginser.cs still remain the orginal become:

Update Employee set EmployeeName=@EmployeeName where
EmployeeID=@Orginal_EmployeeID ;
Select EmployeeID, EmployeeName form Employee where EmployeeID=@EmployeeID;

It also add a @EmployeeID parameter.

Why it add a select command below the update statement?

Thank, I thought this select command is generated when I check "Refersh the data table" in DataTableAdapter wizard.
If I did not check, the Select command will not be generate after the update command.

But can I modify the "Refersh the data table" attribute after DataTableadapter wizard?


  The select statement is added to "refresh" the data in your dataset.  This ensures the data in the dataset matches the database.  It's best practice when persisting data.

  On Wed, 2006-04-05 at 05:09 +0800, ad wrote:
I am using vs2005 to desginer a tableadapter.

I have modify the update command in the desginer, but the update command is
not identical between the desginer.

For example:

The original update command is:

Update Employee set EmployeeID=@EmployeeID and EmployeeName=@EmployeeName
where EmployeeID=@Original_EmployeeID and
EmployeeName=@Original_EmployeeName

I change it in the designer to

Update Employee set EmployeeName=@EmployeeName where
EmployeeID=@Orginal_EmployeeID, and the count of parameter is 2.

But the commandtext in deginser.cs still remain the orginal become:

Update Employee set EmployeeName=@EmployeeName where
EmployeeID=@Orginal_EmployeeID ;
Select EmployeeID, EmployeeName form Employee where EmployeeID=@EmployeeID;

It also add a @EmployeeID parameter.

Why it add a select command below the update statement?

What transaction IsolationLevel for?
Help: Login failed for User ???
Large Datasets
Sorting a Dataset table
IndexOutOfRangeException - Index was outside the bounds of the array.