Datagrid and SqlCommandBuilder

Discussion in 'ASP .Net Datagrid Control' started by microsoft.private.windows.netserver.setup, Mar 6, 2004.

  1. 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.
     
    microsoft.private.windows.netserver.setup, Mar 6, 2004
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Rico Alexander
    Replies:
    1
    Views:
    360
    zPaul
    Oct 23, 2003
  2. microsoft.private.windows.netserver.setup

    Stored Procedures with SQLCommandBuilder

    microsoft.private.windows.netserver.setup, Mar 6, 2004, in forum: ASP .Net
    Replies:
    5
    Views:
    2,856
    microsoft.private.windows.netserver.setup
    Mar 6, 2004
  3. =?Utf-8?B?SmltIFJleW5vbGRz?=

    SqlCommandBuilder

    =?Utf-8?B?SmltIFJleW5vbGRz?=, May 12, 2005, in forum: ASP .Net
    Replies:
    4
    Views:
    2,663
    =?Utf-8?B?SmltIFJleW5vbGRz?=
    May 16, 2005
  4. Andreas Klemt
    Replies:
    0
    Views:
    309
    Andreas Klemt
    Oct 8, 2003
  5. microsoft.private.windows.netserver.setup

    Stored Procedures with SQLCommandBuilder

    microsoft.private.windows.netserver.setup, Mar 6, 2004, in forum: ASP .Net Datagrid Control
    Replies:
    0
    Views:
    137
    microsoft.private.windows.netserver.setup
    Mar 6, 2004
Loading...

Share This Page