Connection with M S Access using asp.net



Connection with M S Access file (which is type (.accdb)) (C#) asp.net



1. Add namespace.

Ans: using System.Data.OleDb;

------ end

2. add Connection.

Ans:
private void Connection()
    {
        OleDbConnection con = new OleDbConnection(@"Provider = Microsoft.ACE.OLEDB.12.0;Data Source = C:\Users\nitin\Desktop\db_testing.accdb;");
        OleDbDataAdapter adp = new OleDbDataAdapter("Select*from table1", con);
        DataTable dt = new DataTable();
        adp.Fill(dt);
        GridView1.DataSource = dt;
        GridView1.DataBind();
    }

------ end  



Inserting :

    private void Insertwithaccess()
    {
        int IsCount = 0;
        string cmdquery = "Insert into table1 (Name,Salary)values('" + txtName.Text.Trim() + "','" + txtSalary.Text.Trim() + "')";
        OleDbCommand objOleDbCommand = new OleDbCommand(cmdquery, con);
        con.Open();
        IsCount = objOleDbCommand.ExecuteNonQuery();
        con.Close();
        if (IsCount > 0)
        { 
            Connection();
            lblmessage.ForeColor = System.Drawing.Color.Green;
            lblmessage.Text = "Data Inserted Successfully.";
        }
        else
        {
            lblmessage.ForeColor = System.Drawing.Color.Red;
            lblmessage.Text = "Data Not Inserted.";
        }
    }





                                                    Connections __________________________

Standard security

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.accdb;
Persist Security Info=False;

                                                                                            Access 2007   Access 2010    Access 2013

With database password


Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.accdb;
Jet OLEDB:Database Password=MyDbPassword;
                                               Access 2007   Access 2010    Access 2013


Standard security (mdb file)

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.mdb; 
Persist Security Info=False;
                                        Access 2000   Access 2002   Access 2003   Access 97
  

With database password  (mdb file) 

  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.mdb;
Jet OLEDB:Database Password=MyDbPassword;
                                    
                                                                                 Access 2000   Access 2002   Access 2003   Access 97


Network Location

Provider=Microsoft.ACE.OLEDB.12.0;
Data Source=\\server\share\folder\myAccessFile.accdb;

                                         Access 2007   Access 2010    Access 2013  

Network Location (mdb file)

Provider=Microsoft.ACE.OLEDB.12.0;
Data Source=\\serverName\shareName\folder\myAccessFile.mdb;

                                       Access 2000   Access 2002   Access 2003   Access 97

Comments

Post a Comment

Popular posts from this blog

how to fetch all HTML Table Records and modify all records accordingly using jquery and Javascript

In my example, I have fetch HTML Table Records and Convert to Class List Object for C# Result: Click Here < script src = "https://ajax.googleapis.com/ajax/libs/jquery/3.6.3/jquery.min.js" ></ script > < script >   $ ( document ). ready ( function () {     // Get the table element     const table = document . getElementsByTagName ( "table" )[ 0 ];     // Get all the table rows     const rows = table . rows ;     // Create an empty array to store the table data     const data = [];     // Loop through each row and get the cell data     for ( let i = 0 ; i < rows . length ; i ++) {       const cells = rows [ i ]. cells ;       const rowData = {};       //new Columns { CharacterName = "", Char = "", Code = "", Decimal = "", Binary = "", Hex = "" },       var stringCon = "new Columns {" ;       /...
Read more

Optimize Process Speed using C#

To optimized code speed you can use System.Diagnostics  Namespace. ============================= using System; using System.Diagnostics; using System.Threading; namespace DiagnoseProcessSpeed {     internal class Program     {         static void Main()         {             Stopwatch sw = Stopwatch.StartNew(); // Start Stopwatch             for (int i = 1; i < 11; i++)             {                 System.Console.WriteLine("Loop : " + i);                 Thread.Sleep(1000);// interval for 1 seconds.             }             sw.Stop(); // End Stopwatch             //sw.Elapsed Contain Process Taking Time in Seconds             System....
Read more

how to Replace null value with 0 Using C#

how to Replace null value with 0 Using C# //here we suppose that objDataTable have data collection as table now access this //datatable object. decimal  j = 0;  j = objDataTable.Rows[0]["Qty"] ==  DBNull .Value ? 0 :  Convert .ToDecimal(objDataTable.Rows[0]["Qty"]); NOTE :- //if   DBNull.value is null  then   "0 " else  "your code here")  // ? = then // : = else Thank You [Sumit Singh Shekhawat]
Read more