Xaml Parse Exception unhandled

Question

0.00/5 (No votes)

See more:

Hi,

I am trying to connect to the access database 2007 and WPF 2010.

I am getting an exception know XAML Parse Exception was unhandled .The invocation of the constructor on type 'Login_Details.MainWindow' that matches specified binding constraints threw an exception Line Number.3 and Line Number.9 position.

C#

public MainWindow()
        {
            InitializeComponent();
            connection();
        }
        public void connection()
        {
            string connectionString = null;
            OleDbConnection cnn;
            OleDbCommand cmd;
            string sql = null;
            connectionString = "@Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Users\\SR010\\Documents\\Login.accdb";
            sql = "Select * from Login";
            cnn = new OleDbConnection(connectionString);
            try
            {
                cnn.Open();
                MessageBox.Show("Connection Opened");
                cmd = new OleDbCommand(sql, cnn);
                cmd.ExecuteNonQuery();
                cmd.Dispose();
                cnn.Close();
                MessageBox.Show("Execute Non Query in OleDbConnection executed !!");
            }
            catch (Exception ex)
            {
                MessageBox.Show("Cannot open connection !" + ex.ToString());
            }
        }
    }
}

Please suggest what has to be done

Thanks in advance

Posted 26-Oct-12 1:12am

Sophia Ranjani Elango

Updated 27-Oct-12 22:08pm

Sandeep Mewara

v2

Add a Solution

Comments

Clifford Nelson 29-Oct-12 19:35pm

You are getting a xaml error, but have not included the xaml. You are not going to get a good answer without providing the xaml

1 solution

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)

Thomas Daniels · Answer 1 · 2012-10-27T22:29:00

Solution 1

You cann't create a connection to a database in the constructor. My debugger told me there's a error in the line

C#

cnn = new OleDbConnection(connectionString);

So, you need to create a connection when the window is loaded, or on a button click, but not in the constructor.

Posted 27-Oct-12 22:29pm

Thomas Daniels