How to populate data from table to dropdown of gridview

Asked Nov 13 '13 at 06:57

Active Nov 13 '13 at 07:05

Viewed 181 times

dropdown in gridview

<asp:TemplateField HeaderText="ProjectModifiedBy" HeaderStyle-BackColor="#C0C0C0" HeaderStyle-BorderColor="Black">
        <ItemTemplate>
              <asp:DropDownList ID="DropDownList1" Width="99%" runat="server">
            </asp:DropDownList>
         </ItemTemplate>                 
    </asp:TemplateField>

code of web method

     <WebMethod()> _
Public Function BindDropDown() As SqlDataReader
    Dim strConnString As String = ConfigurationManager.ConnectionStrings("conString").ConnectionString
    Dim sqlQuery As String

    sqlQuery = "Sp_SelectEmpName"
    Dim con As New SqlConnection(strConnString)
    Dim cmd As New SqlCommand(sqlQuery, con)
    cmd.CommandType = CommandType.StoredProcedure
    Dim reader As SqlDataReader
    con.Open()
    reader = cmd.ExecuteReader()

    Return reader
End Function

this is the code behind method which calls webmethod,what should i write here to bind the empname column data with dropdown of gridview

  Private Sub BindDataDropDown()

  End Sub

asked Nov 13 '13 at 06:57

sona

1,552
3
18
37

http://stackoverflow.com/questions/18656733/how-to-bind-asp-net-dropdownlist-control-in-edititemtemplate-of-gridview-on-edit – senthilkumar2185 Nov 13 '13 at 07:03
Kindly give me the code for code behind page – sona Nov 14 '13 at 04:37
I also 2 reference to you – senthilkumar2185 Nov 14 '13 at 04:40

How to populate data from table to dropdown of gridview

dropdown in gridview

code of web method

this is the code behind method which calls webmethod,what should i write here to bind the empname column data with dropdown of gridview

0 Answers0