### Problem with Typed Dataset ###

[Kiran]

Hi,

I am using typed dataset for Employees Table and found a problem, can anyone tell me what's wrong

Case 1:

Employees Table:
ID: int,Not Null,Idendity, Primary col
Name:varchar(20 ),Not Null
Type: Varchar(5), Null(Allowed)

When I retrieve data and fill into the typed dataset from the above table(select ID,Name from Employees), Works fine

Case 2:

Employees Table:
ID: int,Not Null,Idendity, Primary col
Name:varchar(20 ),Not Null
Type: Varchar(5), Not Null,Default Value: ('')

When I retrieve data and fill into the typed dataset from the above table(select ID,Name from Employees), doesn't work

I get a constraint exception in this case bcos Type column is not selected.

But Type column has a default value(''), It should work right?

doesn't works, any Ideas?????

Thanks
Kiran

[Rogas69]

what constraint exception? can you specify exact error message? what are relationships in your database?
if you have typed dataset that contains three columns, why are you selecting only two?

peter

[Kiran]

Hi,

I need only two columns, that's the reason I am selecting two.

The exception I get is

System.Data.Con straintExceptio n: Failed to enable constraints. One or more
rows contain values violating non-null, unique, or foreign-key constraints.

Thanks
Kiran
"Rogas69" <rogas69@no_spa mers.o2.ie> wrote in message news:%2******** ********@TK2MSF TNGP10.phx.gbl. ..
what constraint exception? can you specify exact error message? what are relationships in your database?
if you have typed dataset that contains three columns, why are you selecting only two?

peter

[Bonnie Berent [C# MVP]]

Kiran,

What's interesting is that the column Default works just fine if you are
programmaticall y adding Rows to the DataTable, just not when you're using the
DataAdapter.Fil l() ... I tried to find some overload of the .Fill() method
that might get around this, but couldn't. Sounds like a bug with the
DataAdapter, but so far I haven't found a way around it.

~~Bonnie

"Kiran" wrote:

Hi,

I am using typed dataset for Employees Table and found a problem, can anyone tell me what's wrong

Case 1:

Employees Table:
ID: int,Not Null,Idendity, Primary col
Name:varchar(20 ),Not Null
Type: Varchar(5), Null(Allowed)

When I retrieve data and fill into the typed dataset from the above table(select ID,Name from Employees), Works fine

Case 2:

Employees Table:
ID: int,Not Null,Idendity, Primary col
Name:varchar(20 ),Not Null
Type: Varchar(5), Not Null,Default Value: ('')

When I retrieve data and fill into the typed dataset from the above table(select ID,Name from Employees), doesn't work

I get a constraint exception in this case bcos Type column is not selected.

But Type column has a default value(''), It should work right?

doesn't works, any Ideas?????

Thanks
Kiran

[Kiran]

Thanks Bonnie

"Bonnie Berent [C# MVP]" <Bo************ **@discussions. microsoft.com> wrote
in message news:CD******** *************** ***********@mic rosoft.com...

Kiran,

What's interesting is that the column Default works just fine if you are
programmaticall y adding Rows to the DataTable, just not when you're using
the
DataAdapter.Fil l() ... I tried to find some overload of the .Fill() method
that might get around this, but couldn't. Sounds like a bug with the
DataAdapter, but so far I haven't found a way around it.

~~Bonnie

"Kiran" wrote:

Hi,

I am using typed dataset for Employees Table and found a problem, can
anyone tell me what's wrong

Case 1:

Employees Table:
ID: int,Not Null,Idendity, Primary col
Name:varchar(20 ),Not Null
Type: Varchar(5), Null(Allowed)

When I retrieve data and fill into the typed dataset from the above
table(select ID,Name from Employees), Works fine

Case 2:

Employees Table:
ID: int,Not Null,Idendity, Primary col
Name:varchar(20 ),Not Null
Type: Varchar(5), Not Null,Default Value: ('')

When I retrieve data and fill into the typed dataset from the above
table(select ID,Name from Employees), doesn't work

I get a constraint exception in this case bcos Type column is not
selected.

But Type column has a default value(''), It should work right?

doesn't works, any Ideas?????

Thanks
Kiran

[Rich]

Can you not just add a dummy column to the select statement? The default is "" so

Select Id, Name, '' as Type from Employees

I have not tried this out but if you have not I would give it a whirl.

Rich

"Kiran" <ki***@gmail.co m> wrote in message news:O0******** ******@tk2msftn gp13.phx.gbl...
Hi,

I am using typed dataset for Employees Table and found a problem, can anyone tell me what's wrong

Case 1:

Employees Table:
ID: int,Not Null,Idendity, Primary col
Name:varchar(20 ),Not Null
Type: Varchar(5), Null(Allowed)

When I retrieve data and fill into the typed dataset from the above table(select ID,Name from Employees), Works fine

Case 2:

Employees Table:
ID: int,Not Null,Idendity, Primary col
Name:varchar(20 ),Not Null
Type: Varchar(5), Not Null,Default Value: ('')

When I retrieve data and fill into the typed dataset from the above table(select ID,Name from Employees), doesn't work

I get a constraint exception in this case bcos Type column is not selected.

But Type column has a default value(''), It should work right?

doesn't works, any Ideas?????

Thanks
Kiran

[Kiran]

I give it a try, thanks
"Rich" <ri**********@i nspiritec.org> wrote in message news:e5******** *****@TK2MSFTNG P09.phx.gbl...
Can you not just add a dummy column to the select statement? The default is "" so

Select Id, Name, '' as Type from Employees

I have not tried this out but if you have not I would give it a whirl.

Rich

"Kiran" <ki***@gmail.co m> wrote in message news:O0******** ******@tk2msftn gp13.phx.gbl...
Hi,

I am using typed dataset for Employees Table and found a problem, can anyone tell me what's wrong

Case 1:

Employees Table:
ID: int,Not Null,Idendity, Primary col
Name:varchar(20 ),Not Null
Type: Varchar(5), Null(Allowed)

When I retrieve data and fill into the typed dataset from the above table(select ID,Name from Employees), Works fine

Case 2:

Employees Table:
ID: int,Not Null,Idendity, Primary col
Name:varchar(20 ),Not Null
Type: Varchar(5), Not Null,Default Value: ('')

When I retrieve data and fill into the typed dataset from the above table(select ID,Name from Employees), doesn't work

I get a constraint exception in this case bcos Type column is not selected.

But Type column has a default value(''), It should work right?

doesn't works, any Ideas?????

Thanks
Kiran