Bien, entonces tenemos un cuadro de texto para, por ejemplo, una "identificación" de algún tipo, como esta:

 <div style="text-align:right;width:300px"> Enter Hotel ID :<asp:TextBox ID="askHotel" runat="server" AutoPostBack="true"></asp:TextBox> <br /> <br /> Hotel Name :<asp:TextBox ID="txtHotel" runat="server" Width="180px"></asp:TextBox> <br /> City :<asp:TextBox ID="txtCity" runat="server" Width="180px"></asp:TextBox> <br /> Active :<asp:CheckBox ID="Active" runat="server" ></asp:CheckBox> </div>

Y nuestro código es:

 Protected Sub askHotel_TextChanged(sender As Object, e As EventArgs) Handles askHotel.TextChanged Using cmdSQL As New SqlCommand("SELECT * FROM tblHotels WHERE ID = @ID", New SqlConnection(My.Settings.TEST4)) cmdSQL.Parameters.Add("@ID", SqlDbType.Int).Value = askHotel.Text cmdSQL.Connection.Open() Dim rst As New DataTable rst.Load(cmdSQL.ExecuteReader) If rst.Rows.Count > 0 Then With rst.Rows(0) txtHotel.Text = .Item("HotelName") txtCity.Text = .Item("City") Active.Checked = .Item("Active") End With End If End Using End Sub

Producción: