procedure problem in asp.net

Posted by Sushant under ASP.NET on 5/28/2013 | Points: 10 | Views : 838 | Status : [Member] | Replies : 2
create procedure sp_DelNewProjectImages
@ImageId int
as
begin
delete from NewProjectImages where ImageId=@ImageId
end
Its giving following error were encounter while parsing the content of SQL pane:
Unable to parse query text.
After that pressing ok
CREATE PROCEDURE sp_DelNewProjectImages ? int AS BEGIN DELETE FROM NewProjectImages
WHERE ImageId = ? END
plz help me

Sushat


Responses

Posted by: Ankitsrist on: 5/28/2013 [Member] Starter | Points: 25

Up
0
Down
there is no problem in your procedure, once check this query by using some value
delete from NewProjectImages where ImageId='your value'

Sushant, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sushant on: 5/28/2013 [Member] Starter | Points: 25

Up
0
Down
ya its working on sql server 2005

but after connection with sql server 2008
its giving error


Error source:Microsoft OLE DB Provider for SQL Server
Error Message:No value given for one or more required parameters.

Sushat

Sushant, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response