I'm trying to delete each row in the database using the Deleting event. I have the following code, which is only deleting the first row. Any suggestions?

Thanks,
Carolyn

    protected void IWSSqlDataSource_Deleting(object sender, SqlDataSourceCommandEventArgs e)
    {
        foreach (SqlParameter param in e.Command.Parameters)
        {
            param.Value = "";
        }
    }

protected void IWSSqlDataSource_Deleting(object sender, SqlDataSourceCommandEventArgs e)
    {
        e.Command.CommandText = "DELETE FROM [IWSMessages]";
    }

Call SqlDataSource.Delete and add the event Deleting to the DataSource.
Put that one line in there and all values are cleared from the table.

Enjoy!
Carolyn