Failed to get schema for this query Visual Studio 2015

Question

I have a page in my program which has a DataGridView object on it. It is populated by a query that selects data from the database table called DOCS.

The table has 4 columns:

applicant_name
doc_id
doc_name
doc_contents

I'm trying to add a delete query for a user to delete a document from the table when they select it and hit the 'delete' button.

When I try to create the delete query, I get the

"Failed to get schema for this query"

message and I can't understand why.

My query looks like this:

DELETE FROM DOCS
WHERE        (doc_id = @Param3)

Could anyone explain why I'm getting this error?

I haven't called it yet, I'm trying to add the query to the tableAdapter of the dataGridView and it won't even let me add it. — Marko Vidalis, Nov 13 '16 at 11:36
use this query for TableAdapter : DELETE FROM [DOCS] WHERE (([doc_id]=@Param3)) — M. Wiśnicki, Nov 13 '16 at 11:45
I ended up creating a query through the code and executing it through an SQLCommand object, by getting the selected row of the datagridview, retrieving the value of the doc_id through the selected row and adding it as a parameter to the query, which works perfectly. — Marko Vidalis, Nov 13 '16 at 13:00

score 0 · Answer 1 · answered Nov 13 '16 at 12:59

0

Are you using data binding to load it from adapter, if yes pz check if I insert update delete statement is generated by adapter.

answered Nov 13 '16 at 12:59

sudeep patel

31
6

The checkboxes for those 3 are selected, i'm not sure how to access them though? – Marko Vidalis Nov 13 '16 at 14:25

Failed to get schema for this query Visual Studio 2015

1 Answers1