Datagrid and SqlCommandBuilder

Datagrid and SqlCommandBuilder

Post by microsoft. » Sun, 07 Mar 2004 14:00:00


Hello everyone, I hope all is well. I have a problem updating a dataset to
the SQL server database. I creates the dataset from a stored procedure.
This selects the whole table. I bind it to a datagrid and use the Key from
the table, then allow the users to change the records, then create a
SqlCommandBuilder to update the database. The update fails because it is
trying to update a column in the dataset that is a formula in SQL
server(which shouldn't be updated as SQl server handles this). I was
wondering if there is a quick method to remove the column from the
sqlAdaptor update method or in the SqlCommandBuilder? I still need to have
the column in the dataset for the user to view, but just shouldn't update
it. Thanks.
 
 
 

1. MVVM: Single datagrid row selection when a datagrid contains another datagrid in side RowDetailsTemplate

2. 3 ANDS + 1 OR

in cell M13

=IF(AND($D13>0,$L13<($E13-$F13),AU13>=AV13),AV13,"NO")
returns a date in if all 3 statements are true, otherwise no.
I want an OR condition IF N13>"", AV13 to come in before the "NO",
so that if all 3 of the first statements are true OR the last statement is
true, the date from AV13 results.

I've fooled around with this for 2 hours now, and I GIVE UP.

Once again, I am turning to the experts to save me.

Thanks

3. multiple ifs ands & indirect or offset?

4. SUMPRODUCT with AND's and OR's?

5. Nesting IF's and AND's - a bit of help please...

6. WMP11 BUG: Advanced Search doesn't work with ANDs

7. Omnipage 14 ands its PDFs

8. Conditional ANDS!

9. Need help sorting out ANDs and ORs in parameter query

10. Multiple ANDs

11. Conditional Statement with ANDs

12. IF's & AND's

13. Proper way to write a conditional statement with ands

14. if & ands and either indirect or offset - need help fast pleas

15. multiple ifs & ands indirect/offset...need help desperately pl