How to bind data to a dropdownlist from database in rowediting

Question

0.00/5 (No votes)

See more:

Hi All,
I want to populate a drop-downlist in the grid view, when editing i want the list of values to select for update.I hv done it with the help of stored procedure that i hv created & used already in my project but it is not working exactly. here is the piece of C# code below;
//This is for RowEditing

C#

  protected void taskgrid_RowEditing(object sender, GridViewEditEventArgs e)
    {
        Load_Projectlist();
        taskgrid.EditIndex = e.NewEditIndex;
        BindTaskList();
    }
//This is for RowUpdating
protected void taskgrid_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        int UserID = UDFLib.ConvertToInteger(Session["USERID"]); 

        
        int PIC = UDFLib.ConvertToInteger((taskgrid.Rows[e.RowIndex].FindControl("ddlPIC") as DropDownList).SelectedValue);
       
        int ProjectID = UDFLib.ConvertToInteger((taskgrid.Rows[e.RowIndex].FindControl("ddlprojectlist")as  DropDownList).SelectedValue);
        int ModuleID = UDFLib.ConvertToInteger((taskgrid.Rows[e.RowIndex].FindControl("ddlmodulelist")as DropDownList).SelectedValue);

        int result = UserTaskProgress.Update_Task( UserID, ProjectID, ModuleID, PIC);
        if (result == 1)
        {
            taskgrid.EditIndex = -1;
            BindTaskList();
            grdresult.Text = "Task updated successfully";

        }
    }
//This is to load the project list
private void Load_Projectlist()
    {
        DataTable dtpl =   UserTaskProgress.Get_ProjectList(UDFLib.ConvertToInteger(Session["USERID"]));
        ddlnewproject.DataSource = dtpl;
        ddlnewproject.DataBind();
        ddlnewproject.Items.Insert(0,new ListItem("-Select-","0"));
        
  }

Need help as I am confused how to do?plz help..

Posted 19-Aug-13 1:31am

Member 10218129

Updated 19-Aug-13 1:32am

Code-Hunt

v2

Add a Solution

Comments

CodeBlack 19-Aug-13 7:37am

Why do you bind your drop down list in RowEditing event as it is going to bind the same list for the same drop down? Better you bind it in page load event.

Member 10218129 19-Aug-13 8:37am

Thanks,I hv done it before,but it cann't improvise the result ,it is same as before..How to do the inline editing for the drop downlist,i want to display the value from the database to the dropdown list

CodeBlack 19-Aug-13 8:58am

where is your dropdown list ? inside grid or outside grid ?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

S.P.Tiwari · Answer 1 · 2013-08-19T03:07:00

C#

protected void taskgrid_RowEditing(object sender, GridViewEditEventArgs e)
    {
        Load_Projectlist();
        taskgrid.EditIndex = e.NewEditIndex;
        BindTaskList();
    //here you will get the dropdown list
        DropDownList ddl = taskgrid.Rows[e.NewEditIndex].FindControl("ddlnewproject") as DropDownList;

//now provide the datasource to dropdown and bind here
//write code here for binding

if(ddl != null)
{
 DataTable dtpl =   UserTaskProgress.Get_ProjectList(UDFLib.ConvertToInteger(Session["USERID"]));
        ddl .DataSource = dtpl;
        ddl .DataBind();
        ddl .Items.Insert(0,new ListItem("-Select-","0"));
    }
}
else
{

// control not found
}

hope this will help