A parameter is passed through drop down show result in grid

Question

protected void DropDownList1_SelectedIndexChanged(object sender EventArgs e) { try { con.Open(); query = select * from OA_PlayerBat where Team_ID =' + ddTeam.SelectedItem + '; SqlCommand cmd = new SqlCommand(query con); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); grdResult.DataSource = ds; grdResult.DataBind(); con.Close(); } this is a drop-down list here user has to select the team to show the results of that team in a grid view. I have made a stored procedure and i am unable to pass the user selected drop down value there.

shifa Ali · Answer

@Francis if you have been through the code you must have noticed that i am trying to compare the selected dropdown value through if-else condition and assign particular value to local variable Team_ID and then trying to send that value to stored procedure. i have already bound the dd to a table in the SQL server. But it is giving null value as a result to selected dd value.

Ehsan Sajjad · Answer

I suspect you need to use SelectedValue property not SelectedItem can you try like: ddTeam.SelectedValue

Francis · Answer

What's your actual problem? Whether you can't pass the param to SP or you don't know how to pass the param to SP?

Ashiwani Sharma · Answer

Hi shifa I think that u are filling the dropdownlist in Page_load event. If yes plz use if (!Page.IsPostBack) { } By this your dropdownlist will not initialize. If this helpful Plz accept as answer.