CODEWITHSUNDEEP
asp.netstored-procedures
johnode
johnode

Reputation: 740

ASP.NET Stored procedure error

I have stored procedure which returns "Tabular data" and have only "Get method".

I unchecked "Fill a DataTable" checkbox. And Method name is empty field.

So, i only have a Get method to get rows from database table.

SQL code works fine when i tried it in SQL management studio.

But when i create a stored procedure, i get an alert:

enter image description here I use BLL/BO/DAL architecture

I call my stored procedure like:

MyDataTable dt = myAdapter.MyStoredProcedure();

And the i get an error:

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

enter image description here

What i am doing wrong?

Upvotes: 0

Views: 74

Answers (1)

Ramesh Rajendran
Ramesh Rajendran

Reputation: 38663

Check this same issues

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

http://forums.asp.net/t/1258783.aspx/2/10

Upvotes: 1

Related Questions