GridView DropDownList column.

Question

0.00/5 (No votes)

See more:

Hi all, I have a web application with entity model as backend. I have the settings set to Edit|Update|Delete set to true in the gridview. I have a separate table for storing a list of choices that I want to fill a certain column in the records. Is there a way to make a DropDownList while in edit mode? I have the property AutoGenerateColumns to true.

I got it - partly. So do not use AutoGenerateColumns and add each column in the column's collection in the DataView with the appropriate fields. Create a new entityDatasource for the dropdownlist and link it to the TemplateField. The problem now is to understand the edit part of this model. When I try to select a member in the dropdownlist it does not update and when I try to update any other fields I get an error. How do I fix the update statements with this setup?

Posted 7-Jul-12 4:47am

Idle_Force

Updated 7-Jul-12 7:02am

v3

Add a Solution

2 solutions

Solution 2

Here, have a look at it how we have dropdown in genral to get the idea on how things are wired up and work: MSDN: Walkthrough: Displaying a Drop-Down List While Editing in the GridView Web Server Control[^]

Posted 7-Jul-12 7:23am

Sandeep Mewara

Comments

Idle_Force 7-Jul-12 15:50pm

So I need to make my own Insert/Update/Delete statements? Do I need an ObjectDatasource?

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)

Idle_Force · Accepted Answer · 2012-07-11T14:18:00

Here's the working model:

VB

Sub dgv_RowDataBound(ByVal sender As Object, ByVal e As GridViewRowEventArgs) Handles dgv.RowDataBound
   If e.Row.RowState = DataControlRowState.Edit Then
     Dim md As Med = CType(e.Row.DataItem, Med)
     Dim _type As String = md.DType
     Dim ddl As DropDownList = CType(e.Row.FindControl("ddlDType"), DropDownList)
     Dim item As ListItem = ddl.Items.FindByText(_type)
     ddl.SelectedIndex = ddl.Items.IndexOf(item)
   End If
 End Sub

 Sub dgv_RowUpdating(ByVal sender As Object, ByVal e As GridViewUpdateEventArgs) Handles dgv.RowUpdating
   Dim row As GridViewRow = dgv.Rows(dgv.EditIndex)
   Dim list As DropDownList = CType(row.FindControl("ddlDType"), DropDownList)
   e.NewValues("DType") = list.SelectedValue
 End Sub

 Private Sub dgv_RowEditing(sender As Object, e As GridViewEditEventArgs) Handles dgv.RowEditing
   If Not dgv.EditIndex = -1 Then
     Try
       Dim row As GridViewRow = dgv.Rows(dgv.EditIndex)
       Dim ddl As DropDownList = CType(row.FindControl("ddlDType"), DropDownList)
       ddl.SelectedIndex = ddl.Items.IndexOf(ddl.Items.FindByText(CType(row.DataItem, Med).DType))
     Catch
     End Try
   End If
 End Sub

XML

<asp:TemplateField  HeaderText="DType" >
    <ItemTemplate >
       <asp:Label ID="lbDT" Text='<%# Bind("DType")%>' runat="server" ></asp:Label>
    </ItemTemplate>
    <EditItemTemplate >
       <asp:DropDownList ID="ddlDType" DataSourceID="edsDDL" DataTextField="types" DataValueField="types" runat="server" ></asp:DropDownList>
    </EditItemTemplate>
</asp:TemplateField>