Help with SQL redundant data prevention

Question

DioRani 0 Unverified User

13 Years Ago

I am currently working a registration project and here is my code..

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.Sql;
using System.Data.SqlClient;

namespace Thesis
{
    public partial class Registration : Form
    {
        Form formParent = null;
        public Registration(Form par)
        {
            formParent = par;
            InitializeComponent();
        }

        private void Registration_FormClosed(object sender, FormClosedEventArgs e)
        {
            formParent.Show();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            string connection = @"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\Granodiorit\Documents\Visual Studio 2008\Projects\Thesis\Thesis\Database1.mdf;Integrated Security=True;User Instance=True";
            SqlConnection cn = new SqlConnection(connection);
            try
            {
                cn.Open();
            }
            catch (Exception)
            {
                MessageBox.Show("Did not connect");
            }

            string username = UserName.Text;
            string password = Password.Text;
            string nickname = Nick.Text;
            string birthday = Birthday.Text;
            string ymail = Ymail.Text;
            string gmail = Gmail.Text;
            string hotmail = Hotmail.Text;
            string yaddress = YAddress.Text;
            string gaddress = GAddress.Text;
            string hotaddress = HotAddress.Text;

            string sqlquery;

            sqlquery = "INSERT INTO [User] (Username, Password, Nick, Birthday, Ymail, Yaddress, Gmail, Gaddress, Hotmail, Hotaddress) VALUES (@UserName, @Password, @Nick, @Birthday, @YMail, @YAddress, @GMail, @GAddress, @Hotmail, @HotAddress)";
            SqlCommand command = new SqlCommand(sqlquery, cn);
            command.Parameters.AddWithValue("@UserName", username);
            command.Parameters.AddWithValue("@Password", password);
            command.Parameters.AddWithValue("@Nick", nickname);
            command.Parameters.AddWithValue("@Birthday", birthday);
            command.Parameters.AddWithValue("@YMail", ymail);
            command.Parameters.AddWithValue("@YAddress", yaddress);
            command.Parameters.AddWithValue("@GMail", gmail);
            command.Parameters.AddWithValue("@GAddress", gaddress);
            command.Parameters.AddWithValue("@Hotmail", hotmail);
            command.Parameters.AddWithValue("@HotAddress", hotaddress);
            command.ExecuteNonQuery();
            this.Close();
            formParent.Show();
        }



        internal void show()
        {
            throw new NotImplementedException();
        }

        private void Registration_Load(object sender, EventArgs e)
        {
            string connection = @"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\Granodiorit\Documents\Visual Studio 2008\Projects\Thesis\Thesis\Database1.mdf;Integrated Security=True;User Instance=True";
            SqlConnection cn = new SqlConnection(connection);
            try
            {
                cn.Open();
            }
            catch (Exception)
            {
                MessageBox.Show("Did not connect");
            }
        }

    }
}

This code works for writing data into SQL.. Now.. My Questions are..
1. How to make a prevention for users to have the same data? (Data redundancy prevention).. The think I would like to have is When the new user put the same data, there will be a warning.. The important key will be the USERNAME and EMAIL ADDRESSES..
2. Make a notification to let the new users knew where is the message.. like a MessageBox..

Thanks in advance.. I am really noob in this.. :)

2 Contributors
4 Replies
116 Views
5 Days Discussion Span
Latest Post 13 Years Ago Latest Post by DioRani

All 4 Replies

kvprajapati 1,826 Posting Genius

13 Years Ago

Use SELECT with WHERE clause.

SqlCommand command = new SqlCommand("select username from [user] where username=@Username" , cn);
 command.Parameters.AddWithValue("@UserName", username);

 object result=command.ExecuteScalar();
 if(result!=null) // found
   {
      //Given username is found 
      return;
    }
 ....

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

DioRani 0 Unverified User · Answer 1 · 2010-10-25T15:39:03+00:00

DioRani 0 Unverified User

13 Years Ago

Can you help me how to implement it to my code?

kvprajapati 1,826 Posting Genius Team Colleague · Answer 2 · 2010-10-25T15:55:19+00:00

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.Sql;
using System.Data.SqlClient;

namespace Thesis
{
    public partial class Registration : Form
    {
        Form formParent = null;
        public Registration(Form par)
        {
            formParent = par;
            InitializeComponent();
        }

        private void Registration_FormClosed(object sender, FormClosedEventArgs e)
        {
            formParent.Show();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            string connection = @"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\Granodiorit\Documents\Visual Studio 2008\Projects\Thesis\Thesis\Database1.mdf;Integrated Security=True;User Instance=True";
            SqlConnection cn = new SqlConnection(connection);
            try
            {
                cn.Open();
            }
            catch (Exception)
            {
                MessageBox.Show("Did not connect");
            }

            string username = UserName.Text;
            string password = Password.Text;
            string nickname = Nick.Text;
            string birthday = Birthday.Text;
            string ymail = Ymail.Text;
            string gmail = Gmail.Text;
            string hotmail = Hotmail.Text;
            string yaddress = YAddress.Text;
            string gaddress = GAddress.Text;
            string hotaddress = HotAddress.Text;

            /* -------------------- */

 SqlCommand command = new SqlCommand("select username from [user] where username=@Username" , cn);
 command.Parameters.AddWithValue("@UserName", username);

 object result=command.ExecuteScalar();
 if(result!=null) // found
   {
       MessageBox.Show("Duplicate username!!!");
      return;
    }

            /* -------------------- */

            string sqlquery;

            sqlquery = "INSERT INTO [User] (Username, Password, Nick, Birthday, Ymail, Yaddress, Gmail, Gaddress, Hotmail, Hotaddress) VALUES (@UserName, @Password, @Nick, @Birthday, @YMail, @YAddress, @GMail, @GAddress, @Hotmail, @HotAddress)";
            command = new SqlCommand(sqlquery, cn);
            command.Parameters.AddWithValue("@UserName", username);
            command.Parameters.AddWithValue("@Password", password);
            command.Parameters.AddWithValue("@Nick", nickname);
            command.Parameters.AddWithValue("@Birthday", birthday);
            command.Parameters.AddWithValue("@YMail", ymail);
            command.Parameters.AddWithValue("@YAddress", yaddress);
            command.Parameters.AddWithValue("@GMail", gmail);
            command.Parameters.AddWithValue("@GAddress", gaddress);
            command.Parameters.AddWithValue("@Hotmail", hotmail);
            command.Parameters.AddWithValue("@HotAddress", hotaddress);
            command.ExecuteNonQuery();
            this.Close();
            formParent.Show();
        }



        internal void show()
        {
            throw new NotImplementedException();
        }

        private void Registration_Load(object sender, EventArgs e)
        {
            string connection = @"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\Granodiorit\Documents\Visual Studio 2008\Projects\Thesis\Thesis\Database1.mdf;Integrated Security=True;User Instance=True";
            SqlConnection cn = new SqlConnection(connection);
            try
            {
                cn.Open();
            }
            catch (Exception)
            {
                MessageBox.Show("Did not connect");
            }
        }

    }
}

DioRani 0 Unverified User · Answer 3 · 2010-10-30T14:08:06+00:00

DioRani 0 Unverified User

13 Years Ago

Thanks.. appreciate it so much.. :)

Help with SQL redundant data prevention

Recommended Answers Collapse Answers

All 4 Replies

Recommended Answers