What is wrong with this one

Question

Hi,
What is wrong with this one

SqlConnection con = new SqlConnection("Server=.\\SQLExpress;Database=patient;uid=sa;pwd=;");
           String Query;
           Query = "Delete from PatientRecords where PatientID='" + TextBox1.Text + "'";
           SqlCommand sqlcmb = new SqlCommand();
           con.Open();
           sqlcmb.Connection = con;

           SqlTransaction sqltran;
           sqltran = con.BeginTransaction();

           sqlcmb.Transaction = sqltran;
           sqlcmb.CommandText = Query;
           sqlcmb.ExecuteNonQuery();

Thanks in Advance,
A.Durga Prasad

durga prasad · Answer

Ya, I got the answer I was missing the last line. SqlConnection con = new SqlConnection("Server=.\SQLExpress;Database=patient;uid=sa;pwd=;"); String Query; Query = "Delete from PatientRecords where PatientID='" + txtPatientID.Text + "'"; SqlCommand sqlcmb = new SqlCommand(); con.Open(); sqlcmb.Connection = con; SqlTransaction sqltran; sqltran = con.BeginTransaction(); sqlcmb.Transaction = sqltran; sqlcmb.CommandText = Query; sqlcmb.ExecuteNonQuery(); sqltran.Commit(); //Missing this line

durga prasad · Answer

The Problem I face here is not with the data types,Everything is running perfectly but values are not getting committed with the data base (ex. The Values is not getting deleted from database).

Amit Tiwari · Answer

sqltran = con.BeginTransaction(); I guess you missed to commit the transaction.

Rama bandapelli · Answer

It depends on what datatype PatientId is TextBox1.text passes a string value with some empty charecters some time, use textbox1.text.Trim().

akhil · Answer

hey Durga Prasad just tell what problem u are facing then only we can help u Is there problem in connection or not deleting record or else so pls be specific with question akhilesh

Ryan Alford · Answer

in the database, is the PatientID an "int"(or other numeric value)?

What is wrong with this one

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (6)