Torna al Thread

OleDbConnection cn1 = new OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" + Server.MapPath("Lam.mdb") + ";"); OleDbCommand cmd2 = new OleDbCommand("qryreg", cn); /* Definisco il Command Type */ cmd.CommandType = System.Data.CommandType.StoredProcedure; /* Definisco i parametri di input */ cmd2.Parameters.Add("user", OleDbType.VarChar).Value = Convert.ToString(Session["Username"]); cmd2.Parameters.Add("pass", OleDbType.VarChar).Value = RipPassword.Text; //cmd2.Parameters.Add("mail", OleDbType.VarChar).Value = Email.Text; cmd2.Parameters.Add("nom", OleDbType.VarChar).Value = Nome.Text; cmd2.Parameters.Add("cognom", OleDbType.VarChar).Value = Cognome.Text; cmd2.Parameters.Add("dat", OleDbType.VarChar).Value = ddG.SelectedValue + "/" + ddM.SelectedValue + "/" + ddA.SelectedValue; cmd2.Parameters.Add("tel", OleDbType.VarChar).Value = Tel.Text; cmd2.Parameters.Add("citt", OleDbType.VarChar).Value = Citta.Text; cmd2.Parameters.Add("prov", OleDbType.VarChar).Value = ddP.SelectedValue; cmd2.Parameters.Add("via", OleDbType.VarChar).Value = Via.Text; /* Apro la connessione ed eseguo la query */ cmd2.Connection.Open(); cmd2.ExecuteNonQuery(); /* Pulizia */ cn1.Close();
Copyright © dotNetHell.it 2002-2024
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5