create a common function for deleting records .

public void deleterecords(string tablename,string id,string fieldname)
{
string m_str;
 m_Str = "delete from "+tablename +"where "+fieldname+"="+id;
            int intResult = new Class1().SqlConExecuteNonQuery(m_Str);
}

deleterecords("PersonalDetails","1","Id");

This code may help you.

May I suggest that you don't actually delete the records, but rather mark them as being deleted through the use of a flag on a record? If you do this, you make it a lot easier for yourself to preserve referential integrity in your application, and that you can provide auditing functionality in a much more straight forward way.

Consider the case where you have a lookup table that you are managing through your application. If the user decides that a record should be deleted, you don't have to worry about deleting all the other records associated with that record - and potentially causing a cascade of deletes that need to be performed (which could have the added side effect of removing data that should still be active).

Obviously this means that you have to filter out the "deleted" records when you read them in, but that's not an overly difficult task.

i have done it :

public int deleteRecord(string tablename,param string []clause)
{

string str="delete from " + tablename + " where clause[i];

}

implement your logic

//create a class in the name of DButility file with some methods which are u want like bellow

public class DbUtility
{
    public DbUtility()
    {
        //
        // TODO: Add constructor logic here
        //
    }

public static SqlConnection OpenConnection()
    {
        SqlConnection cnn = new SqlConnection(ConfigurationManager.ConnectionStrings["YouConnectionString"].ConnectionString);
        if (cnn.State == ConnectionState.Open)
        {
            cnn.Close();
            cnn.Open();
        }
        else
        {
            cnn.Open();
        }
        return cnn;
    }

// then create a method for delete your record like follow

public static int DeleteRecord(string query)
    {
        int i = 0;
        SqlCommand com = new SqlCommand();
        com = new SqlCommand(query, DbUtility.OpenConnection());
        i = com.ExecuteNonQuery();
        DbUtility.CloseConnection();
        return i;
    }

// now if u want to delete your re the just write the bellow code for delete button click

protected void button_Delete_Click(object sender, EventArgs e)
    {
        string qry = "delete * from table_xyz";
        DbUtility.DeleteRecord(qry);
    }

}


// just u need to write only query in cs page...

In pratice, it is often better to have specific code for each tables as it help ensure that you pass the appropriate parameter for the table.

In fact, often code generated by Visual Studio designer already provide a way to delete a row from a table. It might not be as optimal as hand generated code but generally, it will be somewhat safer to use.