|
-
Dec 10th, 2007, 03:48 PM
#1
Thread Starter
Member
[RESOLVED] Stored Procedure for DataGridView
I got an SQL SERVER database and a VB.NET form containing couple of datagridviews and some comboboxes
I linked the grids and boxes with some views and fields from database and they work just fine when form loads
My problem is when I select a value from a combo I want to execute a stored procedure to display certain records in the grids
So the steps I did for that are
in dataset's design view - the tableadapter of a certain table ... Add Querry ... Use existing stored procedure (I made a stored procedure in SQL SERVER)
I selected the stored procedure and selected Tabular Data because I want more than 1 value returned ... I named the methods MyFill and MyGetDataBy and all seem perfect
The problem is in the SelectedIndexChanged method where I want to refresh the datagrids with new values
Me.dbGrid1.DataSource = Me.ComenziTableAdapter.MyGetDataBy("Acr") - Acr is a stored procedure parameter
the error message is :
Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.
thank you
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|