Deleting from database

Expand Post »

Hi
I am trying to delete a name from my database however my code seems to have a problem. It seems to cut out before i actually excutes the SQL statement. Is there something else i have missed in the code. PatientNumber is equal to the value to the text.
This is reading the value for i put MessageBox in to see

I am using C# compact framework and sql ce if it makes any differences

thanks for any help

C# Syntax (Toggle Plain Text)
 
SqlCeConnection  connDB = new SqlCeConnection("Data Source = \\My Documents\\system.sdf");
connDB.Open();
SqlCeCommand sqlDelete = connDB.CreateCommand();
sqlDelete.CommandText = "DELETE FROM Patient WHERE (((name)= + '"PatientName"'+");)"); 		
sqlDelete.ExecuteNonQuery();
connDB.Close();
 
SqlCeConnection  connDB = new SqlCeConnection("Data Source = \\My Documents\\system.sdf");
connDB.Open();
SqlCeCommand sqlDelete = connDB.CreateCommand();
sqlDelete.CommandText = "DELETE FROM Patient WHERE (((name)= + '"PatientName"'+");)"); 		
sqlDelete.ExecuteNonQuery();
connDB.Close();

Similar Threads

Adding a deleting rows in JSP
Hijacked browser freezes in Viruses, Spyware and other Nasties
How to delete a particular row from a datagrid..? in VB.NET
Consider me please, this is not a time pass scripts!! in MS SQL

student_help

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

8 posts
since Feb 2006

Permalink

Mar 29th, 2006

Re: Deleting from database

try this

C# Syntax (Toggle Plain Text)
SqlCeConnection  connDB = new SqlCeConnection("Data Source = \\My Documents\\system.sdf");
connDB.Open();
SqlCeCommand sqlDelete = connDB.CreateCommand();
sqlDelete.CommandText = "DELETE FROM Patient WHERE name= '"+ PatientName+ "'"; 		
sqlDelete.ExecuteNonQuery();
connDB.Close();
SqlCeConnection  connDB = new SqlCeConnection("Data Source = \\My Documents\\system.sdf");
connDB.Open();
SqlCeCommand sqlDelete = connDB.CreateCommand();
sqlDelete.CommandText = "DELETE FROM Patient WHERE name= '"+ PatientName+ "'"; 		
sqlDelete.ExecuteNonQuery();
connDB.Close();

campkev

Reputation Points: 14

Solved Threads: 19

Posting Pro in Training

Offline

484 posts
since Jul 2005

Permalink

Mar 30th, 2006

Re: Deleting from database

Hi thanks that worked.

student_help

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

8 posts
since Feb 2006

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in C# Forum Timeline: using Scripting;

Next Thread in C# Forum Timeline: Error Throwing In Calculator Code When Divided By '0'

DaniWeb Message

Cancel Changes

User Name
Password