Prevent duplication datas...

Cefora Kaja

11y1.3kLearn iOS Programming

Hi!

I have this code to prevent duplicate records but its give me an error message that says:

Object reference not set to an instance of an object.

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.OleDb;

namespace WindowsFormsApplication1

{

public partial class Form1 : Form

{

OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Dont_save_when_record_duplicated\WindowsFormsApplication1\App_data\test.mdb;Persist Security Info=False");

OleDbCommand comm;

string connstr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Dont_save_when_record_duplicated\WindowsFormsApplication1\App_data\test.mdb;Persist Security Info=False";

public Form1()

{

InitializeComponent();

}

private void button1_Click(object sender, EventArgs e)

{

//conn = new OleDbConnection(connstr);

//comm = new OleDbCommand();

//comm.Connection = conn;

conn.Open();

comm.Connection = conn;

connstr = "SELECT COUNT(*) FROM Not_duplicated_datas WHERE [username] = @username";

comm.CommandText = connstr;

comm.Parameters.Clear();

comm.Parameters.AddWithValue("@username", textBox1.Text);

int numRecords = (int)comm.ExecuteScalar();

if (numRecords == 0)

{

connstr = "INSERT INTO Not_duplicated_datas([username],[fillingcode],[branch],[department],[agency])VALUES(@username,@fillingcode,@branch,@department,@agency)";

comm.CommandText = connstr;

comm.Parameters.Clear();

comm.Parameters.AddWithValue("@username", textBox1.Text);

comm.Parameters.AddWithValue("@fillingcode", textBox2.Text);

comm.Parameters.AddWithValue("@branch", textBox3.Text);

comm.Parameters.AddWithValue("@department", textBox4.Text);

comm.Parameters.AddWithValue("@agency", textBox5.Text);

comm.ExecuteNonQuery();

MessageBox.Show("Created Successfully ..");

}

else

{

MessageBox.Show("A record with a user name of {0} already exists", textBox1.Text);

}

conn.Close();

}

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Afzaal Ahmad Zeeshan11y ago
I would still recommend that you read that blog post that I provided you with. It has a great content that you may want to learn in solving the problem.

https://basicsofwebdevelopment.wordpress.com/2014/07/03/what-is-a-null-error-in-code-execution/
0
Cefora Kaja11y ago
That's great! Its works.

Many thanks.
0
Afzaal Ahmad Zeeshan11y ago
Good, thanks for that code. Have a look in your Form's members:
```
OleDbCommand comm;
```
It is not initialized, thus it is null. Try initializing it with some value, for example,
```
OleDbCommand comm = new OleDbCommand(); 
```
Then try again, this time it would be a new object (empty; but existing). The objects which does not exist in the memory currently are more likely to throw this exception. I would recommend that you always make sure that the objects are initialized when you call the constructor for your Form.
0
Cefora Kaja11y ago
The bugg is in this line: comm.Connection = conn;
The error message is: Object reference not set to an instance of an object.
I cant do anything. I am stopped... How can I resolv it. Thanks.
0
Afzaal Ahmad Zeeshan11y ago
On which line?

In any case, you forgot to initialize the variable that is why it is causing a NullReferenceException. You can read this blog post of mine to learn more about this error and how to solve it: https://basicsofwebdevelopment.wordpress.com/2014/07/03/what-is-a-null-error-in-code-execution/
0