Runtime Sqldatasource Delete Command

i need to dyanamically generate my SQL commands so to do that i am generating sqldatasource commands programmatically rather declaratively. SELECT commands seems to work fine but DELETE isnt doing anything, here is my code:

 

SqlDataSource sdsConsultant = new SqlDataSource();

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

loadDataSet();  //it just loads dataset used by formview

initializeSDS();

}





}

protected void initializeSDS()

{

string strConnection = ConfigurationManager.ConnectionStrings["myDB"].ToString();

sdsConsultant.ConnectionString = strConnection;



//SELECT

sdsConsultant.SelectCommand = "SELECT * FROM Consultants WHERE (id=@id)";

QueryStringParameter id = new QueryStringParameter("id", "id");

sdsConsultant.SelectParameters.Add(id);



//DELETE

sdsConsultant.DeleteCommand = "DELETE * FROM Consultants WHERE (id=@id2)";

QueryStringParameter id2 = new QueryStringParameter("id2", "id");

sdsConsultant.DeleteParameters.Add(id2);



//UPDATE

Page.Controls.Add(sdsConsultant);

FormView1.DataSource = sdsConsultant;

FormView1.DataBind();

}

 

my formview control looks like:

<asp:FormView DefaultMode="Edit" ID="FormView1" runat="server" DataKeyNames="id"

OnItemDeleted="FormView1_ItemDeleted"

OnItemDeleting="FormView1_ItemDeleting">

 

the DELETE doesnt execute and the OnItemDeleted event doesnt do anything either. am i doing something wrong here? plz help