«

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

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

Hi,

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

The exception I get is

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

Thanks
Kiran
"Rogas69" <rogas69@no_spamers.o2.ie> wrote in message news:%...
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,

What's interesting is that the column Default works just fine if you are
programmatically adding Rows to the DataTable, just not when you're using the
DataAdapter.Fill() ... 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

Thanks Bonnie

"Bonnie Berent [C# MVP]" <> wrote
in message news:CD38C58B-451F-4F17-BF60-...
> Kiran,
>
> What's interesting is that the column Default works just fine if you are
> programmatically adding Rows to the DataTable, just not when you're using
> the
> DataAdapter.Fill() ... 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

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" <> wrote in message news:...
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

I give it a try, thanks
"Rich" <> wrote in message news:...
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" <> wrote in message news:...
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