Editing gridview : DOTNET

I am creating a gridview that can be edited by the user, and one of the
fields to be edited I want to give the user a drop down which is
populated by a db field. This works fine when the current record being
edited already has a value for the dropdown, but there are cases where
the record might not have a value for the dropdown field, which means
that the SelectedValue property causes the app to crash as there is
nothing in the DB table to populate this record.

Here is my code for the field :

<asp:TemplateField HeaderText="Sponsor" SortExpression="Sponsor">
<ItemTemplate>
<asp:Label ID="lblSponsor" Text='<%#
Eval("Sponsor") %>' runat="server"></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<aspropDownList ID="ddlSponsors"
runat="server" DataSourceID="SqlDataSource2"
DataTextField="Sponsor"
DataValueField="Sponsor" SelectedValue="Sponsor" />
</EditItemTemplate>
</asp:TemplateField>

Can anybody help?



*** Sent via Developersdex http://www.developersdex.com ***

You can handle RowEditing event to select ddl items only if they are there.

--
Eliyahu Goldin,
Software Developer
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net


"Mike P" <mike.parr@gmail.com> wrote in message
news:uBzNQ6wGIHA.4880@TK2MSFTNGP03.phx.gbl...
>I am creating a gridview that can be edited by the user, and one of the
> fields to be edited I want to give the user a drop down which is
> populated by a db field. This works fine when the current record being
> edited already has a value for the dropdown, but there are cases where
> the record might not have a value for the dropdown field, which means
> that the SelectedValue property causes the app to crash as there is
> nothing in the DB table to populate this record.
>
> Here is my code for the field :
>
> <asp:TemplateField HeaderText="Sponsor" SortExpression="Sponsor">
> <ItemTemplate>
> <asp:Label ID="lblSponsor" Text='<%#
> Eval("Sponsor") %>' runat="server"></asp:Label>
> </ItemTemplate>
> <EditItemTemplate>
> <aspropDownList ID="ddlSponsors"
> runat="server" DataSourceID="SqlDataSource2"
> DataTextField="Sponsor"
> DataValueField="Sponsor" SelectedValue="Sponsor" />
> </EditItemTemplate>
> </asp:TemplateField>
>
> Can anybody help?
>
>
>
> *** Sent via Developersdex http://www.developersdex.com ***

Eliyahu,

Do you have a code sample?

Thanks,

Mike


*** Sent via Developersdex http://www.developersdex.com ***

One way of achieving this is to have "not selected" option, perhaps with a
blank value. The DropDownList allows you to append bound items, so you could
have:

<aspropDownList ID="ddlSponsors" runat="server"
DataSourceID="SqlDataSource2"
AppendDtaBoundItems="true"
DataTextField="Sponsor" DataValueField="Sponsor"
SelectedValue="Sponsor">
<asp:ListItem Value="" Text="-- not selected --" />
</aspropDownList>

Dave


"Mike P" <mike.parr@gmail.com> wrote in message
news:uBzNQ6wGIHA.4880@TK2MSFTNGP03.phx.gbl...
>I am creating a gridview that can be edited by the user, and one of the
> fields to be edited I want to give the user a drop down which is
> populated by a db field. This works fine when the current record being
> edited already has a value for the dropdown, but there are cases where
> the record might not have a value for the dropdown field, which means
> that the SelectedValue property causes the app to crash as there is
> nothing in the DB table to populate this record.
>
> Here is my code for the field :
>
> <asp:TemplateField HeaderText="Sponsor" SortExpression="Sponsor">
> <ItemTemplate>
> <asp:Label ID="lblSponsor" Text='<%#
> Eval("Sponsor") %>' runat="server"></asp:Label>
> </ItemTemplate>
> <EditItemTemplate>
> <aspropDownList ID="ddlSponsors"
> runat="server" DataSourceID="SqlDataSource2"
> DataTextField="Sponsor"
> DataValueField="Sponsor" SelectedValue="Sponsor" />
> </EditItemTemplate>
> </asp:TemplateField>
>
> Can anybody help?
>
>
>
> *** Sent via Developersdex http://www.developersdex.com ***

Hi,

Here is a code sample for gridview_rowediting()

protected void gvAmazoneOrders_RowEditing(object sender,
GridViewEditEventArgs e)
{
int index=e.neweditindex;
Dropdownlist sponsers=(DropDownList)
Gridview1.rows[index].findcontrol("ddlSponsors");
//Here check if "sponsers" has the value you want or not.
//like,
for(int i=0;i<sponsers.items.count;i++)
{
if(sponsers.items[i].value=="xyz")
{
sponsers.selectedvalue=sponsers.items[i].value;
break;
}
}
}
}

Hope this will help you.

Regards,
Mansi Shah.

*** Sent via Developersdex http://www.developersdex.com ***