populating a dropdownlist within a datagrid

greenguitar · November 20th, 2004, 02:11 AM

Hi, I'm trying to dynamically populate a dropdownlist within a footer template of a datagrid using vb.net, with no success.

I've tried different methods, here's my latest attempt.

If objArgs.CommandSource.CommandName = "addnew" then
            Dim theddl As DropDownList = CType(objArgs.Item.FindControl("sotdd"), DropDownList)
            strSQL = "SELECT * FROM production_tbl"
            Dim objConnection as New SqlConnection(strConnection)
            Dim objCommand as New SqlCommand(strSQL, objConnection)
            Dim objDataReader as System.Data.SqlClient.SqlDataReader
            response.write(strSQL & "<br>")

            try
            objConnection.Open()
            objCommand.Connection = objConnection
            objCommand.CommandText = "SELECT * FROM production_tbl"
            objDataReader = objCommand.ExecuteReader()
            response.write(objDataReader("client"))

            theddl.DataSource = objDataReader
            theddl.DataTextField = "sotClient"
            theddl.DataValueField = "sotID"
            theddl.DataBind()
             catch when err.number <> 0

                    Response.write(err.description.tostring)

            end try

            objDataReader.Close()
            objConnection.Close()
            exit sub
        End If

I already have a static dropdownlist named "sotdd" sitting in the footer template of the datagrid which looks like this:

<FooterTemplate>
<asp:DropDownList id="sotdd" runat="server" />
</FooterTemplate>

The error I get is object not set to an instance of an object, or no data. I know theres data being pulled from the database, ref. the response.write(objDataReader("client")).

Help! I've being trying for days to get this to work, I've searched everywhere for an answer.

greenguitar · November 22nd, 2004, 01:02 AM

Here is the answer to my own question.

<%@ Page Language="VB" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.SQLClient" %>

<script runat="server">

    dim strSQL as string
    dim strConnection = ConfigurationSettings.AppSettings("DSN")

    Sub Page_Load(sender as object, e as eventargs)

        If not Page.IsPostback then
            BindData()
            PopulateList()
        End If

    End Sub

    Sub BindData()

        strSQL = "SELECT * FROM test_tbl"
           dim objDataSet As New DataSet()
          dim objConnection As New SqlConnection(strConnection)
          dim objDataAdapter As New SqlDataAdapter(strSQL, objConnection)

          objDataAdapter.Fill(objDataSet, "TempInfo")

        DataGrid1.DataSource = objDataSet
        DataGrid1.DataBind()

    End Sub

    Function PopulateList()

        strSQL = "SELECT * FROM sot_tbl"
           dim objDataSet As New DataSet()
          dim objConnection As New SqlConnection(strConnection)
          dim objDataAdapter As New SqlDataAdapter(strSQL, objConnection)

          objDataAdapter.Fill(objDataSet, "TempInfo")

          return objDataSet

    End Function

</script>
<html>
<head>
</head>
<body>
    <form runat="server">
        <asp:DataGrid id="DataGrid1" runat="server" AutoGenerateColumns="False" Width="306px">
            <Columns>
                <asp:BoundColumn DataField="sotID" HeaderText="sotID"></asp:BoundColumn>
                <asp:TemplateColumn HeaderText="sotClient">
                    <ItemTemplate>
                        <asp:DropDownList id="DropDownList1" DataSource="<%# PopulateList %>" DataTextField="sotClient" DataValueField="sotID" runat="server"></asp:DropDownList>
                    </ItemTemplate>
                </asp:TemplateColumn>
            </Columns>
        </asp:DataGrid>

    </form>
</body>
</html>

Easier than I thought. I hope this will help others trying to acheive the same result.