CODEWITHSUNDEEP
c#database-connectionms-access-2007
Taha Kirmani
Taha Kirmani

Reputation: 101

How to View Data from MS Access in Data Grid View?

I am new in C-Sharp, i am trying to access my Database from C-Sharp, i have written the following code, and i dont know what to write next to view data. I have searched this on net but didnt get much. Kindly tell me this in easy code.

string connection = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=F:\Database3.accdb";

OleDbConnection conn = new OleDbConnection(connection);
conn.Open();
OleDbCommand cmd = new OleDbCommand("Select * from score", conn);

OleDbDataAdapter da = new OleDbDataAdapter(cmd);
da.SelectCommand = cmd;

Upvotes: 4

Views: 30359

Answers (3)

BTEUP COURT CASE
BTEUP COURT CASE

Reputation: 1

public void refreshdata()  
{  


    OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\nilu\Desktop\Database1.accdb");  
    OleDbCommand cmd = new OleDbCommand("select * from tbl_data",con);  
    OleDbDataAdapter olda = new OleDbDataAdapter(cmd);  
    DataTable dt = new DataTable();  
    olda.Fill(dt);  
      
  
    GridView1.DataSource = dt;  
    GridView1.DataBind();  


}

Upvotes: 0

Rohit
Rohit

Reputation: 10296

Try this 

        try
        {

        Dataset myDataSet=new Dataset();

        string connection = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=F:\Database3.accdb";
        OleDbCommand cmd = new OleDbCommand("Select * from score", conn);
        OleDbDataAdapter myDataAdapter = new OleDbDataAdapter(cmd );

        connection .Open();
        myDataAdapter.Fill(myDataSet,"TableName");

        }
        catch (Exception ex)
        {
              Console.WriteLine("Error: Failed to retrieve the required data from the DataBase.\n{0}", ex.Message);
              return;
        }
        finally
        {
              connection .Close();
        }

Remember for good coding practice ,always connection should be open in Try Block and closed in Finally Block

Upvotes: 0

Freelancer
Freelancer

Reputation: 9074

Refer following code:

string strProvider = "@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=F:\Database3.accdb";
string strSql = "Select * from score";
OleDbConnection con = new OleDbConnection(strProvider);
OleDbCommand cmd = new OleDbCommand(strSql, con);
con.Open();
cmd.CommandType = CommandType.Text;
OleDbDataAdapter da = new OleDbDataAdapter(cmd);
DataTable scores = new DataTable();
da.Fill(scores);
dataGridView1.DataSource = scores;

Hope its helpful.

Upvotes: 9

Related Questions