当我在下拉列表中选择值时,如何将数据从SQL表中获取到多个文本框 [英] How to get data from SQL table to multiple text boxes when I select value in a dropdown list
问题描述
亲爱的朋友们,
我是asp.net的初学者。 c#
我正在开展一个项目。我有一个带有下拉列表(员工列表)的表单,其中包含SQL表中的值。(TableName- EmployeeDB)
我想获取手机号码,父亲姓名,当我从dropdownlist1中选择EmployeeName时,从SQL表(EmployeeDB)到4个文本框的名称,员工状态。 (例如:员工姓名。当我选择员工姓名时,他的手机号码,父亲姓名,姓名,员工状态将显示在TextBox1,TextBox2,TextBox3,TextBox4中。
请帮助解决此问题的简单代码。
您的代码将帮助我学习。
< b>我尝试了什么:
刚创建了一个带下拉框和文本框的表格。
autopostback on dropdownlist1
Dear Friends,
I am a beginner in asp.net. c#
I am working on a project. I have a form with a dropdown list(List of Employees) with value from SQL Table.(TableName- EmployeeDB)
I want to get the mobile number, father name, designation, employee status from SQL Table(EmployeeDB) to 4 Text Boxes when i select a EmployeeName from dropdownlist1. (example: Employee Name. When i Select Employee Name his mobile number, father name, designation, employee status to be shown in TextBox1,TextBox2,TextBox3,TextBox4.
Please help with a simple code for this issue.
Your code will help me learn.
What I have tried:
Just created a Form with dropdown and text boxes.
autopostback on dropdownlist1
推荐答案
参考这篇文章并开始
使用C#和VB.Net在ASP.Net中基于DropDownList选择填充TextBox [ ^ ]
refer this article and start
Populate TextBox based on DropDownList Selection in ASP.Net using C# and VB.Net[^]
这篇关于当我在下拉列表中选择值时,如何将数据从SQL表中获取到多个文本框的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!