How to read the Gridview

Question

0.00/5 (No votes)

See more:

Hi,
How to read the Gridview dropdown values in the gridview_rowcommand.
I want to update the values based on the dropdown getting values in the gridview_rowcommand.
How to do that?
See my code

<asp:TemplateField HeaderText="From Period" HeaderStyle-HorizontalAlign="Left"> 
                                    <edititemtemplate> 
                                        <asp:DropDownList ID="cmbFrm" runat="server" Style="width: 150px;" 
                                            DataSourceID="dsOtherDept1" DataTextField="FromPeriod" DataValueField="FromPeriod"
                                            AppendDataBoundItems="true">
                                            <asp:ListItem Text="Please Select" Value="">
                                        
                                    </edititemtemplate> 
                                    <itemtemplate> 
                                        <asp:Label ID="lblFrm" runat="server" Text='<%# Eval("FromPeriod") %>'> 
                                    </itemtemplate> 
                                     <HeaderStyle HorizontalAlign="Left" />
                                  
                                 <asp:TemplateField HeaderText="To Period" HeaderStyle-HorizontalAlign="Left"> 
                                    <edititemtemplate> 
                                        <asp:DropDownList ID="cmbTo" runat="server" Style="width: 150px;" 
                                            DataSourceID="dsOtherDept1" DataTextField="ToPeriod" DataValueField="ToPeriod"
                                            AppendDataBoundItems="true">
                                            <asp:ListItem Text="Please Select" Value="">
                                        
                                    </edititemtemplate> 
                                    <itemtemplate> 
                                        <asp:Label ID="lblTo" runat="server" Text='<%# Eval("ToPeriod") %>'> 
                                    </itemtemplate> 
                                     <HeaderStyle HorizontalAlign="Left" />
                                  
                                <asp:TemplateField HeaderText="Edit" ShowHeader="False" HeaderStyle-HorizontalAlign="Left"> 
                                    <edititemtemplate> 
                                        <asp:LinkButton ID="lbkUpdate" runat="server" CausesValidation="True" CommandName="Update"  CommandArgument='<%#Eval("emp_number") %>' Text="Update"> 
                                        <asp:LinkButton ID="lnkCancel" runat="server" CausesValidation="False" CommandName="Cancel" Text="Cancel"> 
                                    </edititemtemplate> 
                                    <itemtemplate> 
                                        <asp:LinkButton ID="lnkEdit" runat="server" CausesValidation="False" CommandName="Edit"  CommandArgument='<%#Eval("emp_number") %>' Text="Edit"> 
                                    </itemtemplate> 
                                    <HeaderStyle HorizontalAlign="Left" />
                                 
                                <asp:CommandField HeaderText="Delete" ShowDeleteButton="True" ShowHeader="True" /> 
                             
                    
                    <asp:SqlDataSource ID="dsOtherDept1" runat="server"   
                            ConnectionString="<%$ConnectionStrings:MPP%>"
                            SelectCommand="Select distinct V.emp_number as emp_number,emp_name+' '+emp_initial as name,emp_designation,Manpower_Division_ID,FromPeriod, ToPeriod from idpeapp.dbo.view_employee V inner join OtherDeptEmp O on V.emp_number = O.emp_number order by name">

ASPX.VB Code
------------

Protected Sub grdDeptEmp_RowCommand(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewCommandEventArgs) Handles grdDeptEmp.RowCommand
        'Dim list As DropDownList = TryCast(e.Row.FindControl("cmbFrm"), DropDownList)
        'cmbFrm.SelectedIndex = cmbFrm.Items.IndexOf(cmbFrm.Items.FindByValue(DataBinder.Eval(e.Row.DataItem, "FromPeriod")))
        Dim emp_number As Integer = Convert.ToInt32(e.CommandArgument)

        If e.CommandName = "update" Then
            'Dim list As DropDownList = TryCast(e.Row.FindControl("cmbFrm"), DropDownList)
            'get the EmpNo of the clicked row
            dsOtherDept1.UpdateCommand  = "update OtherDeptEmp set FromPeriod='" &  & "',ToPeriod='" & & "' where emp_number= '" & EmpNo & "'"
            dsOtherDept1.DataBind()
        End If
    End Sub

Posted 11-Jul-11 18:41pm

gani7787

Updated 11-Jul-11 19:01pm

m@dhu

v2

Add a Solution

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)

arathi_suresh · Answer 1 · 2011-07-13T16:26:00

You can use FindControl in GridView RowCommand event.

Use the following code in GridView RowCommand event.

VB

Dim lbtn As System.Web.UI.WebControls.LinkButton = TryCast(e.CommandSource, System.Web.UI.WebControls.LinkButton)
    If lbtn IsNot Nothing Then
        Dim row As GridViewRow = TryCast(lbtn.NamingContainer, GridViewRow)
        If row IsNot Nothing Then
            Dim cmbFrm As DropDownList = TryCast(row.FindControl("cmbFrm"), DropDownList)
            string fromperiod =cmbFrm.SelectedItem.Value
            'similarly find the control cmbTo and update
        End If
    End If