How to insert record into access database using C#.Net - C#.Net Tutorials

 

Introduction

In this article i will tell you How to insert record into access database using C#.Net.

History

In the Previous articles i explained how to get connection string from web .config filehow to create dynamic xml sitemap in asp.netHow to solve password length minimum 7 non alphanumeric characters required 1How to apply pagination in repeater control using asp.netHow to add my website to google, How to create connection string  and many more about C#.Net.

Step 1.

Use below namespace.

using System.Data.OleDb;

Step 2.

Write below code on click event of the button.

try
        {
        OleDbConnection con = new OleDbConnection("YourConnectionString");
        con.Open();
        OleDbCommand cmd = new OleDbCommand("insert into table1(name,age,class)values('Harish Sharma','22','B.A Part 1')", con);
        cmd.ExecuteNonQuery();
        lbl_msg.Text = "Record inserted successfully.";
        con.Close();
        }
        catch
        {
            lbl_msg.Text ="Error Occured.";
        }

Below is the explanation.

Line 1.

Create connection with your database. Replace "YourConnectionString" with your own connection string.

Line 2.

Open Your Connection.

Line 3.

Create Sql command for inserting records. Here i am inserting the records into columns "name","age","class"of  table "table1". Also pass your connection in oledbcommand.

Line 4.

Execute Query.

Line 5.

Show Message if record inserted successfully.

Line 6.

Close the connection.

Give your Valuable Comments.
comments powered by Disqus
 
Follow me on twitter
About Me
Harpreet Singh
I began programming with C++ when i was 17. Then at the middle of my study .NET came. Then I began to read C# and VB.NET. By the time i learnt SQL and ASP.NET, and developed some websites such as news portals that are active now. Currently i am running my own Software company.
More Articles