What is wrong with this one

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

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).

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