<tr> <td> Area<span class="mandatory">*</span> </td> <td> <asp:UpdatePanel ID="UpdatePanel4" runat="server"> <ContentTemplate> <asp:DropDownList class="w216 dpreq" ID="dparea" runat="server" style="height:25px;" AppendDataBoundItems="true" AutoPostBack="True" OnSelectedIndexChanged="dparea_SelectedIndexChanged"> </asp:DropDownList> </ContentTemplate> <Triggers> <asp:AsyncPostBackTrigger ControlID="dparea" /> </Triggers> </asp:UpdatePanel> </td> </tr>
protected void dparea_SelectedIndexChanged(object sender, EventArgs e) { if (dparea.SelectedIndex != 0) { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Constr"].ConnectionString); con.Open(); SqlDataAdapter adp = new SqlDataAdapter("SELECT [Pincode],stdcode FROM [viewarea] WHERE ([AreaID] = " + dparea.SelectedValue.ToString() + ")", con); DataTable tab = new DataTable(); adp.Fill(tab); string pincode = tab.Rows[0][0].ToString(); string stdcode = tab.Rows[0][1].ToString(); txtpinno.Text = pincode; txtstdcode.Text = stdcode; con.Close(); } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)