A parameter is passed through drop down show result in grid

shifa Ali

10y868.NET

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.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

shifa Ali10y ago
@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.
0
Ehsan Sajjad10y ago
I suspect you need to use SelectedValue property not SelectedItem, can you try like:
ddTeam.SelectedValue
0
Francis Susaimichael10y ago
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?
0
Ashiwani Sharma10y ago
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.
0