Torna al Thread

Imports System.Data.Sql Imports System.Data.SqlClient Imports System.Data.OleDb Imports System.Data Imports System.Data.DataSet Dim myCommand As SqlCommand myConnection = New SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Utenti.mdf;Integrated Security=True;User Instance=True") myConnection.Open() myCommand = myConnection.CreateCommand If myConnection IsNot Nothing Then 'mySqlCommand = New SqlCommand("Insert into Persona (Username,Password,Nome,Cognome,DataNascita,Telefono) VALUES ('TextBox5.Text' ,'TextBox6.Text','TextBox1.Text','TextBox2.Text'," + TextBox3.Text + "," + TextBox4.Text + ")", cn) Dim stringa As String stringa = "Insert into Persona (Username,Password,Nome,Cognome,DataNascita,Telefono) VALUES ('TextBox5.Text' ,'TextBox6.Text','TextBox1.Text','TextBox2.Text'," + TextBox3.Text + "," + TextBox4.Text + ")" myCommand.CommandText = stringa myCommand.ExecuteNonQuery() 'MessageBox.Show("Records affected" & ra) myConnection.Close()
Copyright © dotNetHell.it 2002-2024
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5