Dropdownlist Selected value Binding Problem

Question

0.00/5 (No votes)

See more:

XML

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="ID" DataSourceID="ObjectDataSource1"
            OnRowDataBound="RowDataBound" >
            <Columns>
                <asp:CommandField HeaderText="EDIT" ShowEditButton="True" />
                <asp:BoundField DataField="SNO" HeaderText="SNO" SortExpression="SNO" />
                <asp:TemplateField HeaderText="BASIC ICONURL" SortExpression="BASIC_ICONURL">
                    <EditItemTemplate>
                        <asp:DropDownList ID="DropDownList1" runat="server"
                            SelectedValue='<%# Bind("BASIC_ICONURL") %>' ></asp:DropDownList>
                    </EditItemTemplate>
                    <ItemTemplate>
                        <asp:Label ID="Label1" runat="server" Text='<%# Eval("BASIC_ICONURL") %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:BoundField DataField="BASIC_FILEURL" HeaderText="BASIC FILEURL"
                    SortExpression="BASIC_FILEURL" />
                <asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False"
                    ReadOnly="True" SortExpression="ID" Visible="False" />
            </Columns>
        </asp:GridView>

Imports System.Data
Imports MySql.Data
Imports MySql
Imports MySql.Data.MySqlClient
Partial Class _Default
    Inherits System.Web.UI.Page
    Dim conn As MySqlConnection
    Dim cmd As MySqlCommand
    Dim connstr As String
    Dim strSQL As String
    Dim reader As MySqlDataReader

    Protected Sub RowDataBound(ByVal sender As Object, ByVal e As GridViewRowEventArgs)

        If e.Row.RowType = DataControlRowType.DataRow AndAlso GridView1.EditIndex = e.Row.RowIndex Then

            Dim GV As DropDownList = e.Row.FindControl("DropDownlist1")
            connstr = "server=localhost;User Id=xxxx;password=xxx;Persist Security Info=True;database=xxx"
            strSQL = "select * from pdfmap"
            conn = New MySqlConnection(connstr)
            cmd = New MySqlCommand(strSQL, conn)
            conn.Open()
            reader = cmd.ExecuteReader
            GV.DataSource = reader
            GV.DataTextField = "NAME"
            GV.DataValueField = "BASIC_ICONURL"
            GV.DataBind()
        End If

    End Sub
End Class

When i am trying to Bind in this way im getting error, when i remove "selectedvalue=<%#Bind("BASIC_ICONURL")%>" im not getting error, but data is not updating.

Posted 2-Apr-12 6:45am

nikhlesh565

Add a Solution

2 solutions

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)

Reza Ahmadi · Answer 1 · 2012-04-02T19:37:00

Hi,
The easiest way for your case is to use a SqlDataSource for your DropDownList in the EditItemTemplate tag. You need to remove RowDataBound event handler and let this codes fill and bind data to your DropDownList:

XML

<EditItemTemplate>
                        <asp:DropDownList ID="DropDownList1" runat="server"
                            DataSourceID="SqlDataSource2" DataTextField="NAME" DataValueField="BASIC_ICONURL"
                            SelectedValue='<%# Bind ("BASIC_ICONURL") %>'>
                        </asp:DropDownList>
                        <asp:SqlDataSource ID="SqlDataSource2" runat="server"
                            ConnectionString="<%$ ConnectionStrings:YourConnectionStringKey %>"
                            SelectCommand="SELECT [BASIC_ICONURL], [NAME] FROM [pdfmap]"></asp:SqlDataSource>
                    </EditItemTemplate>

I hope it helps,
Cheers

Reza Ahmadi · Answer 2 · 2012-04-02T23:11:00

Hi,
Well, as I said you need to fill your DropDownList sooner. You must use RowCreated event handler instead of RowDataBound(as it fires sooner) so it is very important to know Page LifeCycle and event raise orders. Here is the new code:

VB

Protected Sub RowCreated(ByVal sender As Object, ByVal e As GridViewRowEventArgs)

        If e.Row.RowType = DataControlRowType.DataRow AndAlso GridView1.EditIndex = e.Row.RowIndex Then

            Dim GV As DropDownList = e.Row.FindControl("DropDownlist1")
            connstr = "server=localhost;User Id=xxxx;password=xxx;Persist Security Info=True;database=xxx"
            strSQL = "select * from pdfmap"
            conn = New MySqlConnection(connstr)
            cmd = New MySqlCommand(strSQL, conn)
            conn.Open()
            reader = cmd.ExecuteReader
            GV.DataSource = reader
            GV.DataTextField = "NAME"
            GV.DataValueField = "BASIC_ICONURL"
            GV.DataBind()
        End If

    End Sub

I mean, just replace RowDataBound with RowCreated. It will probably work as it is the main problem.
I suggest you to examine different event handlers of the GridView. It can help you realize their fire orders.

Feel free to tell me if it does not work,
Cheers

Dropdownlist Selected value Binding Problem

2 solutions

Solution 2

Solution 3

Add your solution here

Preview 0