Bind dropdown list to textbox
Without PostBack bind dropdownlist to textbox
I have a database table with two colums ( column one has all the countries and column two has all the capitols of that particular country.)
In my .aspx page I have a dropdown list and a text box.
Drop downlist will display all the countries and if I select a country then its capitol should be displayed in the textbox, without posting back to the server
Re: Bind dropdown list to textbox
Hi Usha,
Just put the following code in ur Page_Load event and u will get it done.
[CODE]DropDownList1.Attributes("onChange") = "TextBox1.value=this.value"[/CODE]
Don't forget to put the AutoPostBack to false for DropDownListBox1
If u are greedy u would like this link :)
[URL="http://msdn.microsoft.com/en-us/library/aa479302.aspx"]Working with client-side script[/URL]
---V V---
Vikas Vaidya
[I]Please mark it as Thank if u found the comment useful[/I]
Re: Bind dropdown list to textbox
sir,
Thanks for u r reply but it's gvng error
CS0118: 'System.Web.UI.WebControls.WebControl.Attributes' is a 'property' but is used like a 'method'
Thank u..........
Re: Bind dropdown list to textbox
Place the dropdownlist in Ajax updated panel, do u aware of Ajax. If u use ajax it will automatically fill your textbox with out postback, please let me know if u need any help.
Re: Bind dropdown list to textbox
Here the code for u r question
.aspx
------
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<asp:ScriptManager ID="ScriptManager1" runat="server" />
<div>
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>
<asp:DropDownList ID="ddlCountry" runat="server" Width="157px" OnSelectedIndexChanged="ddlCountry_SelectedIndexChanged" AutoPostBack="True">
</asp:DropDownList>
<asp:TextBox ID="txtCapital" runat="server" Style="z-index: 100; left: 13px; position: absolute;
top: 155px"></asp:TextBox>
</ContentTemplate>
</asp:UpdatePanel>
</div>
</form>
</body>
</html>
.aspx.cs
--------
public partial class _Default : System.Web.UI.Page
{
SqlConnection sqlCon;
SqlDataAdapter sqlAdap;
DataSet sqlDs;
string commandText="";
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
commandText = "select countryName from country";
sqlDs = new DataSet();
sqlDs = GetData(commandText);
ddlCountry.DataValueField = "countryName";
ddlCountry.DataSource = sqlDs.Tables[0];
ddlCountry.DataBind();
ddlCountry.Focus();
}
}
protected DataSet GetData(string sqlCommand)
{
string conString = "Trusted_Connection=True;server=localhost;database=master";
sqlCon = new SqlConnection(conString);
sqlAdap = new SqlDataAdapter(sqlCommand, conString);
sqlDs = new DataSet();
sqlAdap.Fill(sqlDs);
return sqlDs;
}
protected void ddlCountry_SelectedIndexChanged(object sender, EventArgs e)
{
commandText = "select countryCapital from country where countryName='"+ ddlCountry.SelectedValue+"'";
sqlDs = new DataSet();
sqlDs = GetData(commandText);
txtCapital.Text = sqlDs.Tables[0].Rows[0][0].ToString();
}
}
In case if u need any other information let me know.
Regards,
Hari Prasad
Re: Bind dropdown list to textbox
Can you use ajax in your application. You can view the ajax control toolkit on below link [url]www.asp.net\ajax[/url]
Re: Bind dropdown list to textbox
Usha,
U can write like this, dropdownlist.Attributes.Add("onchange","funname();");
Script side,
function funname()
{
TextBox1.value=this.value;
}