Binding Dropdownlist in Gridview GridView1_RowUpdating event

Hi,

Can I bind Dropdownlist in GridView1_RowUpdating event, I dont want to bind Dropdownlist on Pageload.

Thanks,

Rahul

Re: Binding Dropdownlist in Gridview GridView1_RowUpdating event

Rahul you can bind your dropdown on rowdatabound event.Or please tell me the condition on which you want to bind dropdown

Re: Binding Dropdownlist in Gridview GridView1_RowUpdating event

Thanks for your reply.

I have taken a dropdown in GridView and I dont want to bind it on PageLoad because of performance issues.

I want to bind the Grid when the user press Edit Link button on Grid View.

I bind the grid on rowdatabound event. Its showing error: Object Referrence not set to an instance of an object.

My Code:

        protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
        {
            DropDownList ddl1 = (DropDownList)e.Row.FindControl("ddl1");
            SqlCommand cmd = new SqlCommand("usp_Bind", con);
            cmd.CommandType = CommandType.StoredProcedure;
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataSet ds1 = new DataSet();
            da.Fill(ds1, "Emp");

            ddl1.DataTextField = "EmpName";
            ddl1.DataSource = ds1.Tables["Emp"];
            ddl1.DataBind();
        }

This code works when the Grid is not in Grid View.

Thanks

Rahul

Re: Binding Dropdownlist in Gridview GridView1_RowUpdating event

Hi,

Your idea is right, it seems no problem with your code, but it shows error "Object Referrence not set to an instance of an object", in my opinion, you have not yet gotten the reference of the DropDownList control correctly, or you havn't instantiate ds1(not query data, null). Please go to this link:

http://www.codeproject.com/Articles/12021/Accessing-the-different-controls-inside-a-GridView

Re: Binding Dropdownlist in Gridview GridView1_RowUpdating event

Where is your DropDownList..In ItemTemplate or EditItemTemplate?

Re: Binding Dropdownlist in Gridview GridView1_RowUpdating event

It is in the EditItem Template

Thanks,

Rahul

Re: Binding Dropdownlist in Gridview GridView1_RowUpdating event

if (e.Row.RowType == DataControlRowType.DataRow)
{
   // your code here....
}
try this code..

Re: Binding Dropdownlist in Gridview GridView1_RowUpdating event

Hi,

The above code is not working on GridView1_RowDataBound.

My Code:

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
        {
            if (e.Row.RowType == DataControlRowType.DataRow)
            {
                DropDownList ddl1 = (DropDownList)e.Row.FindControl("ddl1");
                SqlCommand cmd = new SqlCommand("usp_Referral", con);
                cmd.CommandType = CommandType.StoredProcedure;
                SqlDataAdapter da = new SqlDataAdapter(cmd);
                DataSet ds1 = new DataSet();
                da.Fill(ds1, "Referral");

                ddl1.DataTextField = "RSource";
                ddl1.DataSource = ds1.Tables["Referral"];
                ddl1.DataBind();
            }
        }

Thanks,

Rahul