Hi RichardSa,
Please refer below sample.
HTML
<table>
<tr>
<td>Username: </td>
<td><asp:TextBox ID="txtUsername" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td>Password: </td>
<td><asp:TextBox ID="txtPassword" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td>Email: </td>
<td><asp:TextBox ID="txtEmail" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td>Admin: </td>
<td><asp:TextBox ID="txtAdmin" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td></td>
<td><asp:Button ID="btnSubmit" runat="server" Text="Submit" OnClick="OnSubmit" /></td>
</tr>
</table>
Namespaces
C#
using System.Data;
using System.Configuration;
using System.Data.SqlClient;
VB.Net
Imports System.Data
Imports System.Configuration
Imports System.Data.SqlClient
Code
C#
protected void OnSubmit(object sender, EventArgs e)
{
string conString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
using (SqlConnection con = new SqlConnection(conString))
{
using (SqlCommand cmd = new SqlCommand("SELECT * FROM userTable WHERE Email=@Email OR Username=@Username", con))
{
cmd.Parameters.AddWithValue("@Email", txtEmail.Text.Trim());
cmd.Parameters.AddWithValue("@Username", txtUsername.Text.Trim());
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('" + "Record already exist." + "')", true);
con.Close();
}
else
{
con.Close();
con.Open();
string conString1 = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
using (SqlConnection con1 = new SqlConnection(conString1))
{
using (SqlCommand cmd1 = new SqlCommand("Insert INTO userTable VALUES(@Username, @Password, @Email, @Admin)", con))
{
cmd1.Parameters.AddWithValue("@Username", txtUsername.Text.Trim());
cmd1.Parameters.AddWithValue("@Email", txtEmail.Text.Trim());
cmd1.Parameters.AddWithValue("@Password", txtPassword.Text.Trim());
cmd1.Parameters.AddWithValue("@Admin", txtAdmin.Text.Trim());
cmd1.ExecuteNonQuery();
con1.Close();
ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('" + "Record Inserted Sucessfully." + "')", true);
}
}
}
}
}
}
VB.Net
Protected Sub OnSubmit(ByVal sender As Object, ByVal e As EventArgs)
Dim conString As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
Using con As SqlConnection = New SqlConnection(conString)
Using cmd As SqlCommand = New SqlCommand("SELECT * FROM userTable WHERE Email=@Email OR Username=@Username", con)
cmd.Parameters.AddWithValue("@Email", txtEmail.Text.Trim())
cmd.Parameters.AddWithValue("@Username", txtUsername.Text.Trim())
con.Open()
Dim dr As SqlDataReader = cmd.ExecuteReader()
If dr.HasRows Then
ClientScript.RegisterStartupScript(Me.GetType(), "alert", "alert('" & "Record already exist." & "')", True)
con.Close()
Else
con.Close()
con.Open()
Dim conString1 As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
Using con1 As SqlConnection = New SqlConnection(conString1)
Using cmd1 As SqlCommand = New SqlCommand("Insert INTO userTable VALUES(@Username, @Password, @Email, @Admin)", con)
cmd1.Parameters.AddWithValue("@Username", txtUsername.Text.Trim())
cmd1.Parameters.AddWithValue("@Email", txtEmail.Text.Trim())
cmd1.Parameters.AddWithValue("@Password", txtPassword.Text.Trim())
cmd1.Parameters.AddWithValue("@Admin", txtAdmin.Text.Trim())
cmd1.ExecuteNonQuery()
con1.Close()
ClientScript.RegisterStartupScript(Me.GetType(), "alert", "alert('" & "Record Inserted Sucessfully." & "')", True)
End Using
End Using
End If
End Using
End Using
End Sub