All columns in my dataset are read only -- How do I make them updateable

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Hugh Barnett (hughbarnett_at_cox.net)
Date: 11/02/04 

Date: 2 Nov 2004 12:09:15 -0800

Using Visual Studio wizards, I generated an Odbc connection to a
Sybase DB; an Odbc data adapter that uses stored procedures for the
select and update commands; and a data set. I added a data grid and
set the data source property to the data set and the data member
property to the stored procedure.

The columns in the data set are all read only = true, and when I run
the fill, I get the data, but nothing is updateable.

How can I make the columns updateable? I tried adding the code
DataSet1.spSelectRequests.ColorIDColumn.ReadOnly = False, thinking
that the column ColorID would become updateable, but that didn't work.

Thanks.
Hugh Barnett
National Spinning Co.

Relevant Pages

  • Re: Views vs Stored Procedures, whats the difference?
    ... sometimes the optimizer doesn't do what is best. ... It teaches data set ... upgrade to stored procedures. ... However, if you utilize a stored procedure, you can utilize your ...
    (comp.databases.ms-sqlserver)
  • Re: SQL Server 2000 stored procedures or view
    ... Both view and stored procedures return data set for the report. ... If you're building a report then the updatability is irrelevant since a report is output by definition so that's not something that decides if you want to use a view or a SP. ...
    (microsoft.public.sqlserver.programming)