QueenRock
16-09-2004, 14:18
Tui có làm thử một đoạn code như ở duới, mỗi khi nhấn nút thì Status sẽ hiện lên tên người trong đó, nhưng nội dung trong dropdownlist thì được tăng thêm n lần. Có cách nào để khi nhấn nút thì nội dung trong dropdownlist không tăng lên không
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.SQL" %>
<script language="VB" runat="server">
Sub Page_Load(Source As Object, E As EventArgs)
Dim myCommand As SQLCommand
Dim myReader As SQLDataReader
Dim SQL as String
Dim connStr as String
connStr="Server=localhost;uid=sa;pwd=;database=hocasp"
SQL="select * from NHP_NHANSU"
myCommand = new SQlCommand(SQL, connStr)
myCommand.ActiveConnection.Open()
myCommand.Execute(myReader)
while myReader.Read()
HoTen.Items.add(new ListItem(trim(myReader.Item("HoTen")), myReader.Item("id")))
end while
end Sub
Sub HienTen(Source As Object, E As EventArgs)
Status.Text = HoTen.SelectedItem.Text
end sub
</script>
<form runat="server">
<asp:DropDownList runat="server" onChange="HienTen" id="HoTen">
</asp:DropDownList>
<BR>
<asp:button text="Hien thi" onClick="HienTen" runat="server"/>
<BR>
<asp:Label id="Status" runat="server"/>
</form>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.SQL" %>
<script language="VB" runat="server">
Sub Page_Load(Source As Object, E As EventArgs)
Dim myCommand As SQLCommand
Dim myReader As SQLDataReader
Dim SQL as String
Dim connStr as String
connStr="Server=localhost;uid=sa;pwd=;database=hocasp"
SQL="select * from NHP_NHANSU"
myCommand = new SQlCommand(SQL, connStr)
myCommand.ActiveConnection.Open()
myCommand.Execute(myReader)
while myReader.Read()
HoTen.Items.add(new ListItem(trim(myReader.Item("HoTen")), myReader.Item("id")))
end while
end Sub
Sub HienTen(Source As Object, E As EventArgs)
Status.Text = HoTen.SelectedItem.Text
end sub
</script>
<form runat="server">
<asp:DropDownList runat="server" onChange="HienTen" id="HoTen">
</asp:DropDownList>
<BR>
<asp:button text="Hien thi" onClick="HienTen" runat="server"/>
<BR>
<asp:Label id="Status" runat="server"/>
</form>