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 typesEverything 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)?