Guest User

Untitled

a guest
Oct 19th, 2017
119
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.38 KB | None | 0 0
  1. <connectionStrings>
  2. <add name="SicConnectionString"
  3. connectionString ="Data Source=ETID-012312\ETID012312;User=sa;Password=admin2312;Initial Catalog=Sic_db;Integrated Security=True;"
  4. providerName="System.Data.SqlClient" />
  5. </connectionStrings>
  6.  
  7. @{
  8. Layout = "~/_SiteLayout.cshtml";
  9. Page.Title = "Cadastro";
  10.  
  11. var fantasia = "";
  12. var cnpj = "";
  13. var cep = "";
  14. var endereco = "";
  15. var estado = "";
  16. var cidade = "";
  17. var bairro = "";
  18. var celular = "";
  19. var telefone = "";
  20. var email = "";
  21. var usuario = "";
  22. var senha = "";
  23. var csenha = "";
  24. var error = false;
  25. var resultado = "";
  26.  
  27. if (IsPost)
  28. {
  29. var db = Database.OpenConnectionString("Data Source=;User=;Password=;Initial Catalog=;Integrated Security=True;");
  30. fantasia = Request.Form["fantasia_txv"];
  31. cnpj = Request.Form["cnpj_txv"];
  32. cep = Request.Form["cep_txv"];
  33. endereco = Request.Form["endereco_txv"];
  34. estado = Request.Form["estado_txv"];
  35. cidade = Request.Form["cidade_txv"];
  36. bairro = Request.Form["bairro_txv"];
  37. celular = Request.Form["celular_txv"];
  38. telefone = Request.Form["telefone_txv"];
  39. email = Request.Form["email_txv"];
  40. usuario = Request.Form["usuario_txv"];
  41. senha = Request.Form["senha_txv"];
  42. csenha = Request.Form["csenha_txv"];
  43.  
  44. // Define the insert query. The values to assign to the
  45. // columns in the Product table are defined as parameters
  46. // with the VALUES keyword.
  47.  
  48. var insertQuery = "INSERT INTO dbo.TempAcc (TA_fantasia, TA_cnpj, TA_cep, TA_endereco, TA_estado, TA_cidade, TA_bairro, TA_celular, TA_telefone, TA_email, TA_usuario, TA_senha)" +
  49. "VALUES (@0, @1, @2, @3, @4, @5, @6, @7, @8, @9, @10, @11)";
  50. db.Execute(insertQuery, fantasia, cnpj, cep, endereco, estado, cidade, bairro, celular, telefone, email, usuario, senha);
  51. // Display the page that lists products.
  52. }
  53. }
  54.  
  55. <add name="SicConnectionString"
  56. connectionString ="Data Source=ETID-012312\ETID012312;User=sa;Password=admin2312;Initial Catalog=Sic_db;Integrated Security=True;"
  57. providerName="System.Data.SqlClient" />
  58.  
  59. <add name="SicConnectionString"
  60. connectionString ="Data Source=ETID-012312\ETID012312;User Id=sa;Password=admin2312;Initial Catalog=Sic_db;Integrated Security=True;"
  61. providerName="System.Data.SqlClient" />
  62.  
  63. var db = Database.OpenConnectionString("Data Source=;User ID=;Password=;Initial Catalog=;Integrated Security=True;");
Add Comment
Please, Sign In to add comment