How do I delete records using data reader?

The procedure for updating records using INSERT commands is very similar to the one we presented in the previous example (of SELECT) except that here the command does not return anything and thus the method to call on the SqlCommand object is called ExecuteNonQuery().

C# Version

	string connString = "server=FARAZ; database=programmersheaven;" +
				  "uid=sa; pwd=";
	SqlConnection conn = new SqlConnection(connString);
			
	// DELETE Query
	string cmdString =  "DELETE FROM Author " + 
				"WHERE authorId = 3";
	SqlCommand cmd = new SqlCommand(cmdString, conn);
	conn.Open();
	cmd.ExecuteNonQuery();
	conn.Close();

VB.Net Version

        Dim connString As String = "server=FARAZ; database=programmersheaven;" + _
                                   "uid=sa; pwd="
        Dim conn As New SqlConnection(connString)
        ' DELETE Query
        Dim cmdString As String =  "DELETE FROM Author " + 
                                   "WHERE authorId = 3"
        Dim cmd As New SqlCommand(cmdString, conn)
        conn.Open()
        cmd.ExecuteNonQuery()
        conn.Close()

Back

 

Advertisement

Free Magazine