.net 2005 gridview

Question

Hi, I'm trying to add a lookup type column to a gridview. The column will be used as a picklist of values for the user to, well, pick a value from. Sounds fairly straight forward but the problem is I want the picklist column to be a distinct list from a table that is not in the datasource of the gridview. If I join the picklist table into my datasource I may not get the full list of values, if I create a union I suspect I'll get multiple entries in the picklist column. So I think I need to join the picklist column to another datasource or...? Dunno? over to you folks (hopefully) and thanks for any help offered.

WILL

Answer 1

You can create a template column that contains a dropdownlist. You can then have the dropdownlist be databound by anything including a seperate objectdatasource.

<asp:TemplateField HeaderText="Lookup">
    <itemtemplate>
        <asp:DropDownList runat="server" DataSourceId="SeperateDataSource" SelectedValue='<%# Bind("ValueThatIsSelectedUID") %>' ></asp:DropDownList>
        <asp:ObjectDataSource runat="server" id="SeperateDataSource" selectmethod="SomeSelectMethod"></asp:ObjectDataSource>
    </itemtemplate>
</asp:TemplateField>

The template field also supports edititemtemplate, footertemplate and headertemplate.

Answer 2

You're going to need to make an edit template that has a dropdown list in it. Then inside your gridview's databound event, you'll need code to fill the ddl:

protected void grdGrid_RowDataBound(object sender, GridViewRowEventArgs e) 
{ 

  if (grdGrid.EditIndex == e.Row.RowIndex) 
  { 
    ddlMine = (DropDownList)e.Row.Cells[0].FindControl("ddlMine"); 
    //bind ddlMine
  }
}

Answer 3

check the url below

http://asimsajjad.blogspot.com/2009/04/dropdownlist-binding-in-gridview-aspnet.html

hope that will help.