Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
2
Reply
How to bind textboxes based on selection of dropdownlist??
Rajneesh Chaubey
Jan 13 2018 2:05 AM
157
Reply
Hi I have table named tbl_Employee having columns Employee_name,Emp_ID,Emp_Salary,Emp_State,Emp_Mobile Number.
Now I have an aspx page where I used a dropdownlist and binded with the dtabase which when we click we get all Employee name from that dropdownlist.
Here is the code:-
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand("SELECT EmpId, Name FROM tblEmployee"))
{
cmd.CommandType = CommandType.Text;
cmd.Connection = con;
con.Open();
ddlEmployee
.DataSource = cmd.ExecuteReader();
ddlEmployee
.DataTextField = "Name";
ddlEmployee
.DataValueField = "EmpId";
ddlEmployee
.DataBind();
con.Close();
}
}
ddlEmployee.Items.Insert(0, new ListItem("--Select Employee--", "0"));
}
}
Now on the same page I have 3 textbox named txtname, txtMobile, and txtState. So I want to bind the value from database to those textbox on selection of particular employee to that drop downlist.
For Ex. If have selected Empname 'ABC' those 3 textboxes should be bind with the value of ABC name, ABC mobile and his State.
How do I do that?? Do I have to use Jquery??
Please help me.
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
2
)
Next Recommended Forum
How to validate a edit item template in gridview whn updatin
WEB API POST Method