CODEWITHSUNDEEP
c#sqlasp.netvisual-studioms-access
Mo Al-azzani Gawi
Mo Al-azzani Gawi

Reputation: 19

Adding data to Access database using C#

I'm playing around with C# and Access databases trying to connect them and insert data through a web to the Access database, however I keep getting this:

"A first chance exception of type 'System.Data.OleDb.OleDbException' occurred in System.Data.dll"

on my output console and get nothing else.

not sure what I'm doing wrong but any help will do. Thanks

here's my code for getting the connection:

public partial class reg_Test : System.Web.UI.Page
{

private static OleDbConnection GetConnection()
{
    String connString;
    connString = @"Provider=Microsoft.JET.OLEDB.4.0;Data Source=C:\Users\Wisal\Documents\Visual Studio 2012\WebSites\WebSite3\test-db1.mdb";

    return new OleDbConnection(connString);

}

here's my code for the submit button after user fill the text boxes Name and Surname:

protected void submitButtn_Click(object sender, EventArgs e)
{
    OleDbConnection myConnection = GetConnection();
    String TextBox1 = nameBox.Text;
    String TextBox2 = snameBox.Text;

    try
    {
        myConnection.Open();
Console.WriteLine("Connection Opened");
String myQuery = "INSERT  INTO client values ([name], surname) values ('" + nameBox.Text + "','" + snameBox.Text + "');";


OleDbCommand myCommand = new OleDbCommand(myQuery, myConnection);
myCommand.ExecuteNonQuery();
    }





    finally
    {
        myConnection.Close();
    }
}
}

Upvotes: 0

Views: 867

Answers (1)

Kaushik Maheta
Kaushik Maheta

Reputation: 1861

Change your query statement like below.

    myConnection.Open();
    Console.WriteLine("Connection Opened");
    String myQuery = "INSERT INTO client([name], surname) values ('" + nameBox.Text "','"+ snameBox.Text + "');";
    OleDbCommand myCommand = new OleDbCommand(myQuery, myConnection);
    myCommand.ExecuteNonQuery();

Upvotes: 1

Related Questions