قواعد بيانات access

جرب الكونكشن التالي :

//create the database connection
OleDbConnection MyConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\MyDB.mdb");

طريقة الكونيكش لو سمحت

هذا مثال كامل :

using System;
using System.Data.OleDb;

class OleDbTest{

public static void Main()
{
//create the database connection
OleDbConnection aConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\db1.mdb");

//create the command object and store the sql query
OleDbCommand aCommand = new OleDbCommand("select * from emp_test", aConnection);
try
{
aConnection.Open();

//create the datareader object to connect to table
OleDbDataReader aReader = aCommand.ExecuteReader();
Console.WriteLine("This is the returned data from emp_test table");

//Iterate throuth the database
while(aReader.Read())
{
Console.WriteLine(aReader.GetInt32(0).ToString());
}

//close the reader 
aReader.Close();

//close the connection Its important.
aConnection.Close();
}

//Some usual exception handling
catch(OleDbException e)
{
Console.WriteLine("Error: {0}", e.Errors[0].Message);
}
}
}

جزاك الله خير شباب

انا عندى كود لكن بيعطين خط لو امكن حد يصحح لى الخطا

وجزاكم الله خير

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using WindowsFormsApplication1;

namespace testaccess
{
    public partial class Form7 : Form
    {
        testaccess.db1 CDB1Opj;

        public Form7()
        {
            InitializeComponent();
            CDB1Opj = new testaccess.db1();
        }

        private void Form7_Load(object sender, EventArgs e)
        {
            DGVinfo.DataSource = testaccess.db1.GetAllInfo("city");
        }

        private void DGVinfo_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {

        }
    }
}