Unable to cast object of type System.Web.UI.WebControls.GridViewRow to type System.Web.UI.WebCont

ROHIT says:

 newListItem.Text = myReader.GetValue(myReader.GetOrdinal("SH_NAME"))

                newListItem.Value = myReader.GetValue(myReader.GetOrdinal("SH_NAME"))

 Here you have to use id for value field like

newListItem.Value = myReader.GetValue(myReader.GetOrdinal("SH_ID"))

So that you will able to get value like below to apply the condition.

Dim selectedValue As Integer = Convert.ToInt32(ddltype.SelectedValue)

if SH_NAME having more then one

SH_NAME='ccc'  

then it is giving me last dropdown's id  SH_ID = '39' but SH_ID is = '2' 

Hi ROHIT,

You need to check the newListItem there you are binding to drop down.  So you have to check that. Also one thing you cann't ask multiple queries within a question. This is against forum rules and necessary to maintain clean forum. It is requested. Mark Answer the replies when question is answered and ask a new question as a responsible member to help fellow programmers around the world. Note: If you don't mark answers, people will loose interest in your questions.

want to get the selected row id  

object reference not set to an instance of an object 

Dim abc As String = TryCast(gvDataBig.SelectedRow.FindControl("cmbShowName"), DropDownList).Text

                                        <asp:GridView ID="gvDataBig" CssClass="mGrid" AlternatingRowStyle-CssClass="alt" DataKeyNames="SH_ID" Width="100%" Height="100%"  runat="server" AutoGenerateColumns="False" >
                                            <HeaderStyle />
                                            <AlternatingRowStyle />
                                            <columns>
                                                <asp:BoundField DataField="SH_TIMEBAND" HeaderText="Timeband" ItemStyle-HorizontalAlign="Left" ItemStyle-Wrap="true" HeaderStyle-HorizontalAlign="Center" />
                                                <asp:BoundField DataField="SH_NAME" HeaderText="ProgramName" ItemStyle-HorizontalAlign="Left" ItemStyle-Wrap="true" />
                                                <asp:TemplateField HeaderText="dd" ItemStyle-Width="25px">
                                                    <ItemTemplate>
                                                        <asp:DropDownList ID="cmbShowName" Width="225px" AutoPostBack="True" OnSelectedIndexChanged="DropDown_SelectedIndexChanged" runat="server" CssClass="form-control">                     
                                                        </asp:DropDownList>
                                                    </ItemTemplate>
                                                </asp:TemplateField>                                                                                                
                                            </columns>
                                        </asp:GridView>  

SQL = "UPDATE TICKER_SHOWNAME SET SH_NAME='" & fixQuotes(ddltype.SelectedItem.Text) & "'  WHERE SH_ID='" & abc& "'"