asp.net

[selvamuthu]

how to set values in drop-down box when loading html. please let me know about how to use vbscrip onload event of body.

[SheSaidImaPregy]

something like this:

<form runat="server">
...
<asp:DropDownList ID="ddl1" runat="server" />
...
</form>

<script runat="server" language="vb">
Sub Page_Load(ByVal S As Object, ByVal E As EventArgs)
  Dim conn As New SqlConnection( connectionstring )
  Dim cmd As New SqlCommand ("SELECT company, mfgID FROM Manufacturers", conn)
  Dim dtrReader As SqlDataReader

  Try
    conn.Open()
    dtrReader = cmd.ExecuteReader()
    if dtrReader.HasRows then
      ddl1.DataSource = dtrReader
      ddl1.DataTextField = "company"
      ddl1.DataValueField = "mfgID"
      ddl1.DataBind()
    end if
    dtrReader.Close()
    conn.Close()
  Catch
  End Try
End Sub