Torna al Thread

Private Sub RichiamaDati(ByVal key As String) Dim mdbCon As New MySql.Data.MySqlClient.MySqlConnection() Dim dr As MySql.Data.MySqlClient.MySqlDataReader Dim constring As String, queryString As String Dim fun As New MyFun constring = "Server=" & SERVER_CONNESSIONE & ";Database=" & DB & ";User id=" & USER & ";Pwd=" & PSW & ";Port=" & PORT & ";" mdbCon.ConnectionString = constring queryString = "SELECT * FROM testi WHERE IDTAG='" & key & "';" Dim command As New MySql.Data.MySqlClient.MySqlCommand(queryString, mdbCon) command.Connection.Open() dr = command.ExecuteReader() If dr.HasRows = True Then dr.Read() TextBox1.Text = dr("IDTAG") TextBox6.Text = RitornaTesto(key, fun.Ritorna_Valore_Lingua("ITA")) TextBox5.Text = RitornaTesto(key, fun.Ritorna_Valore_Lingua("ENG")) TextBox7.Text = RitornaTesto(key, fun.Ritorna_Valore_Lingua("GER")) TextBox8.Text = RitornaTesto(key, fun.Ritorna_Valore_Lingua("FRA")) TextBox9.Text = RitornaTesto(key, fun.Ritorna_Valore_Lingua("RUS")) TextBox10.Text = RitornaTesto(key, fun.Ritorna_Valore_Lingua("ESP")) Session("TESTO") = key End If mdbCon.Close() End Sub
Copyright © dotNetHell.it 2002-2024
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5