How to delete record from access database using C#.Net - C#.Net Samples

 

Introduction

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

History

In the Previous articles i explained How 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 googleHow to create connection stringhow to insert record into access database using c#.net, how to update record into access database using c#.net  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("Delete from table1 where name='Harish Sharma'", con);
        cmd.ExecuteNonQuery();
        lbl_msg.Text = "Record Deleted 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 Deleting records from table1. Here i am Deleting the records from table1 where name is "Harish Sharma". Also pass your connection in oledbcommand.

Line 4.

Execute Query.

Line 5.

Show Message if record Deleted 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