runtime sqldatasource sql commands- HELP

iori · August 14th, 2006, 05:38 PM

I need to dynamically generate my SQL commands so to do that i am generating sqldatasource commands programmatically rather declaratively. Here is my code:

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:

Code:

<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