prob in gridview at dropdown list select event

[vikas upadhyay]

following is the code i write

 
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
   {
         SqlCommand com1 = new SqlCommand("quot;select sno,adv,city from adv1 where categry=@b",con);
         com1.Parameters.AddWithValue("@b", DropDownList1.Text);
         con.Open();
         GridView1.DataSource = com1.ExecuteReader();
         con.Close();
         GridView1.DataBind();
}
 

and under grid view i write following

protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
      {
            GridView1.PageIndex = e.NewPageIndex;
            GridView1.AllowPaging = true;
      }

it gives error"The data source does not support server-side data paging."
anyone can help?

[bhuvaneswaran]

protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
   {
         SqlCommand com1 = new SqlCommand("quot;select sno,adv,city from adv1 where categry=@b",con);
         com1.Parameters.AddWithValue("@b", DropDownList1.Text);
         con.Open();
         GridView1.DataSource = com1.ExecuteReader();
         con.Close();
         GridView1.DataBind();
}

This coding is wrong
--------------------------------------

coding is

SqlCommand com1 = new SqlCommand("quot;select sno,adv,city from adv1 where categry=@b",con);
         com1.Parameters.AddWithValue("@b", DropDownList1.Text);
 
         SqlDataAdapter adp = new SqlDataAdapter(com1);
         DataSet ds = new DataSet();
         adp.Fill(ds);
         GridView1.DataSource = ds;
         GridView1.DataBind();

[Frinavale]

Your code is not necessarily "wrong"...it's just that when you use the ExecuteReader it returns data from the database and that data is not pageable unless you put it into a control that is (Like a DataView for example).

Or you could do what bhuvaneswaran suggested and use a dataset instead :)