Populate ASP.NET textbox from combobox selected index change
<p>I am very new to ASP.NET.</p>

<p>I have a an ASP.NET page with an AJAX Combobox and a TextBox. The combobox populates from a database and has value of ID and displays Name. The textbox should display Address. All i want to do is change the value in the Address textbox when the index on the Name combo box changes.
And then be able to change the address and save it back to the database.
How do I do this (simple?) task?</p>

<p>Code so far...</p>

<pre><code>&lt;form id="form1" runat="server"&gt;
    &lt;div&gt;
        &lt;asp:ComboBox ID="ComboBox1" runat="server" DataSourceID="AccessDataSource1" DataTextField="CompositeName"
            DataValueField="Id" MaxLength="0" Style="display: inline;" 
            AutoCompleteMode="SuggestAppend" 
            onselectedindexchanged="ComboBox1_SelectedIndexChanged"&gt;
        &lt;/asp:ComboBox&gt;
        &lt;asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/App_Data/StudentDB.accdb"
            SelectCommand="SELECT [Id], [Name], [Address] FROM [tblStudents]"&gt;
        &lt;/asp:AccessDataSource&gt;
    &lt;/div&gt;
    &lt;asp:TextBox ID="TextBox1" runat="server"&gt;&lt;/asp:TextBox&gt;
    &lt;/form&gt;
</code></pre>
