connecting to MS Access RSS

• • Reply
  

  colol

  Member

  117 Points

  542 Posts

  connecting to MS Access

  Sep 10, 2012 12:47 AM|LINK

  Good morning everyone, i was wondering if anyone has a simple example on how to connect to MS Access whether by registration or displaying data? Thank you

  • Moved by mbanavige on Sep 10, 2012 12:49 AM
• • Reply
  

  subhash.shel...

  Contributor

  2137 Points

  487 Posts

  Re: connecting to MS Access

  Sep 10, 2012 01:43 AM|LINK

  Hi,

  You can connect database using below string...

  public OleDbConnection oleConn;

  public void connect()
  {
              try
              {
                  string ConnStr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=TestDB.mdb;Persist Security Info=True;";
                  oleConn = new OleDbConnection(ConnStr);
  
                  oleConn.Open();
  
              }
              catch (Exception ex)
              {
                  throw ex;
              }
          }

  public DataSet GetData()
  {
  connect();
  adpt = new OleDbDataAdapter("Select * From Registration", oleConn);
  dset = new DataSet();
  dset.Clear();
  adpt.Fill(dset, "Registration");

  if (oleConn.State == ConnectionState.Open)
  {
  oleConn.Close();
  }

  return dset;
  }

  
  
  

  Thanks
  Subhash
  
  Please, Mark as Answer if this reply helped you.
  • Marked as answer by colol on Sep 10, 2012 03:41 AM