Question

On button Click I want to Set the Select command of a Gridview. I do this and then databind the grid but it doesn t work. What am i doing wrong?

 protected void bttnView_Click(object sender, EventArgs e)
{
  ImageButton bttnView = (ImageButton)sender;
    String param1 = bttnView.CommandArgument.Split( , )[0];
    String param2 = bttnView.CommandArgument.Split( , )[1];
    String param3 = bttnView.CommandArgument.Split( , )[2];

    SDSIncidentNotes.SelectCommand = "select * from table Where param1 = " + param1 + " and param2 = " + param2+ " and param3 = " + param3 ;


    GridView1.DataBind();
    UpdatePanel2.Update();
}

Answer 1

Hard to say with the little info you gave but are any of the parameters strings? If so you need to get quotes in there.

SDSIncidentNotes.SelectCommand = "select * from table Where param1 = " + param1 + " and param2 = " + param2+ " and param3 = " + param3 + " " ;

Answer 2

The GridView1 datasource IS (still) bound to SDSIncidentNotes isn t it?

友情链接