CodingForums.com - View Single Post - C# SqlCommandBuilder not performing delete

alykins · 02-13-2013, 09:05 PM

I hardly ever use the dataadapter- I use straight up cmd objects and stored procs... but...

so that delete command you posted... I assume that is captured off a break point on myAdapter.DeleteCommand = etc ?

so my question is this... that is not a valid sql statement...

Code:

DELETE FROM [dbo].[DisplayList] WHERE (([PropertyID] = @p1) AND 
([DisplayID] = @p2) AND ([DisplayName] = @p3) AND ((@p4 = 1 AND 
[TerminalID] IS NULL) OR ([TerminalID] = @p5)))

it should pop an error, unless you have those values @p1,@p2, etc... if you DO have those values, have you tried running that query in SQLManagement studio?

02-13-2013, 09:05 PM	PM User \| #2
alykins Senior Coder Join Date: Apr 2011 Posts: 1,608 Thanks: 37 Thanked 183 Times in 182 Posts	I hardly ever use the dataadapter- I use straight up cmd objects and stored procs... but... so that delete command you posted... I assume that is captured off a break point on myAdapter.DeleteCommand = etc ? so my question is this... that is not a valid sql statement... Code: DELETE FROM [dbo].[DisplayList] WHERE (([PropertyID] = @p1) AND ([DisplayID] = @p2) AND ([DisplayName] = @p3) AND ((@p4 = 1 AND [TerminalID] IS NULL) OR ([TerminalID] = @p5))) it should pop an error, unless you have those values @p1,@p2, etc... if you DO have those values, have you tried running that query in SQLManagement studio? __________________ I code C hash-tag .Net Reference: W3C W3CWiki .Net Lib Validate: html CSS Debug: Chrome FireFox IE