Guest User

Untitled

a guest
Feb 21st, 2018
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.21 KB | None | 0 0
  1. <%@ Page Title="" Language="C#" MasterPageFile="~/Site.master"
  2. AutoEventWireup="true" CodeFile="Register.aspx.cs" Inherits="Register" %>
  3.  
  4. <asp:Content ID="Content1" ContentPlaceHolderID="MainContent"
  5. Runat="Server">
  6. <head>
  7. <link href="Style/Register.css" rel="stylesheet" />
  8. </head>
  9. <body>
  10. <div class="login-page">
  11. <div class="form">
  12. <form class="register-form">
  13. <input id="username" type="text" placeholder="Username" Runat="Server"/>
  14. <input id="password" type="password" placeholder="Password" Runat="Server" />
  15. <input id="confirm" type="password" placeholder="Confirm password" Runat="Server"/>
  16. <input id="email" type="text" placeholder="Email address" Runat="Server"/>
  17. <input id="phone" type="text" placeholder="Phone Number" Runat="Server"/>
  18. <input id="name" type="text" placeholder="Name" Runat="Server"/>
  19. <button onclick="Button1_Click">create</button>
  20. <p class="message">Already registered? <a href="login.aspx">Sign In
  21. <asp:SqlDataSource ID="SqlDataSource1" runat="server"
  22. ConnectionString="<%$ ConnectionStrings:regisString %>"
  23. SelectCommand="SELECT * FROM [regis]">
  24. </asp:SqlDataSource>
  25. </a></p>
  26. </form>
  27. </div>
  28. </div>
  29. </body>
  30. </asp:Content>
  31.  
  32. using System;
  33. using System.Collections.Generic;
  34. using System.Linq;
  35. using System.Web;
  36. using System.Web.UI;
  37. using System.Web.UI.WebControls;
  38. using System.Data.SqlClient;
  39. using System.Configuration;
  40. using System.Data;
  41.  
  42. public partial class Register : System.Web.UI.Page
  43. {
  44.  
  45. protected void Page_Load(object sender, EventArgs e)
  46. {
  47. if (IsPostBack)
  48. {
  49. SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["regisString"].ConnectionString);
  50. conn.Open();
  51. string checkuser = "select count(*) from Regis where username='" + username.Value + "'";
  52. SqlCommand cmd = new SqlCommand(checkuser, conn);
  53. int temp = Convert.ToInt32(cmd.ExecuteScalar().ToString());
  54.  
  55. if (temp == 1)
  56. {
  57. Response.Write("Student Already Exist");
  58. }
  59.  
  60. conn.Close();
  61. }
  62.  
  63. }
  64. protected void Button1_Click(object sender, EventArgs e)
  65. {
  66. try
  67. {
  68. SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["RegisString"].ConnectionString);
  69. conn.Open();
  70. string insertQuery = "insert into Regis(username,password,email,phone)values (@username,@password,@email,@phone,@name)";
  71. SqlCommand cmd = new SqlCommand(insertQuery, conn);
  72. cmd.Parameters.AddWithValue("@username",username.Value);
  73. cmd.Parameters.AddWithValue("@password",password.Value);
  74. cmd.Parameters.AddWithValue("@email",email.Value);
  75. cmd.Parameters.AddWithValue("@phone",phone.Value);
  76. cmd.Parameters.AddWithValue("@phone", name.Value);
  77.  
  78. cmd.ExecuteNonQuery();
  79.  
  80. Response.Write("Student registeration Successfully!!!thank you");
  81.  
  82. conn.Close();
  83.  
  84. }
  85. catch (Exception ex)
  86. {
  87. Response.Write("error" + ex.ToString());
  88. }
  89. }
  90. }
Add Comment
Please, Sign In to add comment