Error When running application

Question

0.00/5 (No votes)

See more:

A created a MS Access file with fields and designed a C# form to insert data into these fields. This is the block of code written to insert a textbox field to the database.

C#

private void button1_Click(object sender, EventArgs e)
        {
            string insertCommand = "INSERT into tblContact (First Name) " + " VALUES( + fntxtbx.Text + )";

            OleDbConnection datacon = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Users\\CROSSLINK\\Documents\\Visual Studio 2008\\Projects\\contact1.mdb");

            OleDbCommand dbcommand = new OleDbCommand( insertCommand, datacon );
                       
            dbcommand.Connection = datacon;
            datacon.Open();
            
            OleDbDataAdapter b = new OleDbDataAdapter();

            DataSet dset = new DataSet();

            b.Fill(dset);
            datacon.Close();
        }

When I tried to running the application the following "unhandled Exception" error appeared...

Unhandled exception has occurred in your application. If you click....
The SelectCommand property has not been initialized before calling "Fill"

Please how can I resolve this issue? Do I have to keep the access file running before this can work or what?

Posted 23-Nov-10 21:39pm

HubSnippets

Updated 23-Nov-10 21:52pm

Sandeep Mewara

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Rod Kemp · Answer 1 · 2010-11-23T21:46:00

The problem is that you have created the OleDbDataAdapter but you haven't assigned the OleDbCommand to it.
After;

C#

OleDbDataAdapter b = new OleDbDataAdapter();

Put;

C#

b.SelectCommand = dbcommand ;

or you can write it as;

C#

b.SelectCommand = new OleDbCommand(insertCommand, datacon );

And change your query to;

C#

string insertCommand = "INSERT into tblContact (First Name) VALUES('" + fntxtbx.Text.Replace("'","''") + "')";

Otherwise any names with an apostrophe will cause errors and open things up for a Sql injection attack.

**JF2015** · Answer 2 · 2010-11-23T21:49:00

Hi,

try this:

private void button1_Click(object sender, EventArgs e)
{
  string insertCommand = "INSERT into tblContact (First Name) " + " VALUES( + fntxtbx.Text + )";

  OleDbConnection datacon = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Users\\CROSSLINK\\Documents\\Visual Studio 2008\\Projects\\contact1.mdb");

  OleDbCommand dbcommand = new OleDbCommand( insertCommand, datacon );

  dbcommand.Connection = datacon;
  datacon.Open();

  OleDbDataAdapter b = new OleDbDataAdapter();
  b.SelectCommand = dbcommand;
  DataSet dset = new DataSet();

  b.Fill(dset);
  datacon.Close();
}

You forget to set the "SelectCommand" that you had already createdd

Error When running application

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0