private void InserirTeste_Click(object sender, EventArgs e) { IDbConnection conexao; StringConexao stringConexao = new StringConexao(); //string stringConexao = @"Data Source = (localdb)\MSSQLLocalDB; Database = Teste; User ID = sa; Password = senha; TrustServerCertificate = True; Trusted_Connection = False; Connection Timeout = 300; Integrated Security = False; Persist Security Info = False; Encrypt = false; MultipleActiveResultSets = True;"; conexao = new SqlConnection(stringConexao.getStringConexao()); conexao.Open(); var listaTeste = new List <Teste>(); try { IDbCommand insertCmd = conexao.CreateCommand(); insertCmd.CommandText = "insert into Teste values('Teste - '+ CONVERT(varchar, getdate(), 121))"; IDataReader resultado = insertCmd.ExecuteReader(); } catch (Exception ex) { throw new Exception(ex.Message); } finally { conexao.Close(); } }
private void TestarConexao_Click(object sender, EventArgs e) { IDbConnection conexao; StringConexao stringConexao = new StringConexao(); //string stringConexao = @"Data Source = (localdb)\MSSQLLocalDB; Database = Teste; User ID = sa; Password = senha; TrustServerCertificate = True; Trusted_Connection = False; Connection Timeout = 300; Integrated Security = False; Persist Security Info = False; Encrypt = false; MultipleActiveResultSets = True;"; conexao = new SqlConnection(stringConexao.getStringConexao()); conexao.Open(); var listaTeste = new List <Teste>(); try { IDbCommand selectCmd = conexao.CreateCommand(); selectCmd.CommandText = "Select * from Teste"; IDataReader resultado = selectCmd.ExecuteReader(); while (resultado.Read()) { var conexaoTeste = new Teste() { Texto = Convert.ToString(resultado["Texto"]), }; listaTeste.Add(conexaoTeste); } ExibirMensagem.Controls.Clear(); int espaco = 25; int posicao = 20; List <Label> ListaMensagens = new List <Label>(); foreach (Teste obj in listaTeste) { Label label = new Label(); label.Text = obj.Texto; label.Top = posicao; this.Controls.Add(label); posicao += espaco; ExibirMensagem.Controls.Add(label); } } catch (Exception ex) { throw new Exception(ex.Message); } finally { conexao.Close(); } }