ASP.NET

The ANZAC wrote:

First of all, how do i populate the combobox with data from this table (column: towns)

<br />
<br />
In form_load event, <br />
<br />
     <code>   <br />
        SqlConnection dbConn = new SqlConnection(connectionString);<br />
<br />
        dbConn.Open();<br />
<br />
        SqlDataAdapter da = new SqlDataAdapter("SELECT town FROM table1", dbConn);<br />
        DataSet ds = new DataSet();    <br />
        da.Fill(ds);<br />
<br />
        dbConn.Close();<br />
<br />
        DropDownList1.DataSource = ds.Tables[0];<br />
        DropDownList1.DataTextField = "town";<br />
        DropDownList1.DataValueField  = "postalcode";<br />
        DropDownList1.DataBind();<br />

The ANZAC wrote:

second of all, when i change item, how do i make the textbox display the postcode (a.k.a. zip code) (column: postcode).

protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)<br />
    {<br />
       txtPostalCode.Text = DropDownList1.SelectedValue;<br />
    }

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message". Why vote? Plz Read it here. Thank you.

onchange="window.open('PageToOpen.aspx','_blank');"

onchange="window.open('PageToOpen.aspx?someNiftyName='+this.options[this.selectedIndex].value,'_blank');"

TheDropDownListControl.Attributes("onchange") = "window.open('PageToOpen.aspx','_blank');"

bnbdnb wrote:

Where do these codes go?

Is there javascript involved?

I also forgot to mention I am coding this in asp.net in a web form not a windows app.