I create a dataSet upon a DB view.
Null values are not allowed in the view : all the null values from the
DB are changed into constants. e.g. string null : "strNull" and int
null -5.
The view is created like this :
CREATE VIEW myView (
vID,
vName,
vOrderNo
) AS
SELECT
Tab1.ID,
isnull(Tab1.Name, 'strNull'),
isnull(Tab1.OrderNo, -5)
FROM Tab1
When tab1 is a table in my SQL Server 2000 DB.
When generating the DataSet, the attribute msdata:readOnly=true is set
to all the column with the isnull... description, without any
connection to the nullify attribute in the DB. The issue is that I
really dont want this attribute to be true.
Is there any way to change this attribute before generation ? I don't
want to get into the xml file and changed it 'cause the generation is
somewhat an automatic process.
10x,
Keren.