Problems In Deleting Record

nkrust · January 12th, 2007, 07:57 AM

Hi,
I'm trying to Delete a record in a table but its not getting deleted.. i'm listing the code below. I suppose there's some mistake .. but not sure where..

Code:

MyReportTableAdapter myReports = new MyReportTableAdapter();
myReports.DeleteReport(ID, "Report"); //ID is string

------
This is the code to access the DB in the xsd file

<DeleteCommand>
<DbCommand CommandType="Text" ModifiedByUser="True">
<CommandText>DELETE FROM TblMyRpts WHERE     (MUserID = :UserID) 
        AND (MRptId =  (SELECT  RptID FROM TblRpts   WHERE   (RptName = :ReportName)))
</CommandText>
<Parameters>
<Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="UserID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="ReportName" Precision="0" Scale="0" Size="0" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
</Parameters>
</DbCommand>
</DeleteCommand>

------------------------------------------------------------------------------------------------------------
Adventure, Play, Alive, Fast, Race, Addict, React, Attack, Heat, Aggression, Blast, Ahead, Escape, Challenge, Anarchy, Game, Real, Damage, Insane, Acclerate,Passion, Fear, Dominate, Crazy, Awesome, Sweat, Habit, Avenge, Balls, Imagine, Viril, Chaos, Amuse, Heavy, Panic, @#!%, Fanatic

dparsons · January 12th, 2007, 09:40 AM

If a record isn't deleteing it is probably because of your WHERE statement being incorrect. Are you sure that the above code is actually connecting to the database? Have you printed out the SQL statement to verifiy the row you are trying to delete actually exists in the database?

-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature

nkrust · January 12th, 2007, 11:52 PM

The query is correct as it works when i directly run it on the database. I'm sure this is the code that's connecting to the db, i just copy pasted it from the .xsd file. And yes the row is present in the DB, strangely enough if instead of the inner query i give the RptId directly it works, so i assume its something else that i might b overlooking. If there's another way to do it please let me know.

------------------------------------------------------------------------------------------------------------
Adventure, Play, Alive, Fast, Race, Addict, React, Attack, Heat, Aggression, Blast, Ahead, Escape, Challenge, Anarchy, Game, Real, Damage, Insane, Acclerate,Passion, Fear, Dominate, Crazy, Awesome, Sweat, Habit, Avenge, Balls, Imagine, Viril, Chaos, Amuse, Heavy, Panic, @#!%, Fanatic