Insert database using MS Access in C#

Question

It doesn't have an error, but it has a message box showing Ms Access Database Engine and data not insert to database. Can anyone help me solve the problem??

namespace WindowsFormsApplication1
{
    public partial class SignUp : Form
    {
        public SignUp()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            OleDbConnection conn = new OleDbConnection();
            conn.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\Junz\Documents\Register - Copy.mdb";
            conn.Open();
            String Username = textBox1.Text;
            String Password = textBox2.Text;
            String Email = textBox3.Text;
            String Address = textBox4.Text;

            OleDbCommand cmd = new OleDbCommand("INSERT INTO Register(Username,Password,Email,Address) Values(@Username, @Password,@Email,@Address)");
            cmd.Connection = conn;

            if (conn.State == ConnectionState.Open)
            {
                cmd.Parameters.Add("@Username", OleDbType.VarChar,20).Value = Username;
                cmd.Parameters.Add("@Password", OleDbType.VarChar,20).Value = Password;
                cmd.Parameters.Add("@Email", OleDbType.VarChar,20).Value = Email;
                cmd.Parameters.Add("@Address", OleDbType.VarChar,20).Value = Address;

                try
                {
                    cmd.ExecuteNonQuery();
                     MessageBox.Show("DATA ADDED");
                       conn.Close();
                }
                catch (OleDbException ex)
                {
                    MessageBox.Show(ex.Source);
                    conn.Close();
                }
            }
            else
            {
                MessageBox.Show("Connection Failed");
            }
        }
    }
}

If you want to find out the details of the exception, then use ex.ToString(). — John Saunders
– John Saunders, Commented Dec 5, 2013 at 4:59

John Saunders · Accepted Answer · 2013-12-05 04:58:41Z

1

ExecuteNonQuery() will return int value representing number of rows updated into Database.

if the returned value is 0 you can Display a Message saying DATA NOT ADDED

Try This: write your try block as below.

   try
   {
        if(cmd.ExecuteNonQuery()>0)
         MessageBox.Show("DATA ADDED");
        else
         MessageBox.Show("DATA NOT ADDED");

        conn.Close();
    }

edited Dec 5, 2013 at 4:58

John Saunders

162k26 gold badges252 silver badges403 bronze badges

answered Dec 5, 2013 at 4:23

Sudhakar Tillapudi

26.3k5 gold badges43 silver badges70 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user3068582 Over a year ago

No, I don't know which part of my program went wrong.It just keep showing Ms Access Database Engine in the messagebox when i click the register button.

Sudhakar Tillapudi Over a year ago

@user3068582: could you please attach screenshot?

Angelo · Accepted Answer · 2013-12-06 08:06:55Z

how about this hope it helps

private void button1_Click(object sender, EventArgs e)
    {
        OleDbConnection conn = new OleDbConnection();
        conn.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\Junz\Documents\Register - Copy.mdb";
        conn.Open();
        String Username = textBox1.Text;
        String Password = textBox2.Text;
        String Email = textBox3.Text;
        String Address = textBox4.Text;

        conn.Open();
        cmd.Connection = conn;
        cmd.CommandType = CommandType.Text;
        cmd.CommandText = "INSERT INTO Register(Username,Password,Email,Address) Values(@Username, @Password,@Email,@Address)";


        if (conn.State == ConnectionState.Open)
        {
            cmd.Parameters.Add("@Username", OleDbType.VarChar,20).Value = Username;
            cmd.Parameters.Add("@Password", OleDbType.VarChar,20).Value = Password;
            cmd.Parameters.Add("@Email", OleDbType.VarChar,20).Value = Email;
            cmd.Parameters.Add("@Address", OleDbType.VarChar,20).Value = Address;

            try
            {
                cmd.ExecuteNonQuery();
                 MessageBox.Show("DATA ADDED");
                   conn.Close();
            }
            catch (OleDbException ex)
            {
                MessageBox.Show(ex.Source);
                conn.Close();
            }
        }
        else
        {
            MessageBox.Show("Connection Failed");
        }
    }

Luis de Haro · Accepted Answer · 2013-12-05 04:55:32Z

0

Add this to your catch

catch (OleDbException ex){
    MessageBox.Show(ex.Message);
    conn.Close();
}

And try to insert again, maybe u can see the exact error now.

Good luck.

answered Dec 5, 2013 at 4:55

Luis de Haro

7391 gold badge7 silver badges29 bronze badges

Collectives™ on Stack Overflow

Insert database using MS Access in C#

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related