Solved

How to embed MS Access table in .net form

Posted on 2011-02-10
8
332 Views
Last Modified: 2012-05-11
I want to embed Access table on a .net form instead of a table/datagrid showing the same data. How can this be done?
0
Comment
Question by:rishaan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
8 Comments
 
LVL 83

Expert Comment

by:CodeCruiser
ID: 34866698
Not sure what you mean.
0
 

Author Comment

by:rishaan
ID: 34871386
Access table is very powerful with all the filter capability. I want to show that table on a .net form.
0
 
LVL 83

Accepted Solution

by:
CodeCruiser earned 500 total points
ID: 34871450
Three options,

1) Dont use winforms. Use Access only.

2) Use winforms and show Access on your form
http://www.codeproject.com/KB/miscctrl/AppControl.aspx

3) Use winforms and try to provide maximum functionality using controls like grid etc.
0
Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

 
LVL 83

Expert Comment

by:CodeCruiser
ID: 34871460
0
 

Author Comment

by:rishaan
ID: 34871695
In winforms I have different charts based on table..and now I wanted to show the data too with filter capability without writing code for datagrid  to have that complex filtering..
Will this http://www.codeproject.com/KB/miscctrl/AppControl.aspx
work for embedding Access..That is what I am looking..If actually someone embedded Access
0
 
LVL 83

Expert Comment

by:CodeCruiser
ID: 34871765
Yes. Give it a try.
0
 

Author Comment

by:rishaan
ID: 34874300
       axWebBrowser1.Navigate(sFileName, ref refmissing, ref refmissing, ref refmissing, ref refmissing); Not matching any overload.....
        If I use
axWebBrowser1.Navigate(sFileName);
But it opens in a seaprate window...
0
 

Author Comment

by:rishaan
ID: 34874376
Added following code---Opens mdb in seaparate  window..
object oDocument;
 
private void button1_Click(object sender, EventArgs e)
 {
 string sFileName;
 openFileDialog1.FileName = "";
 openFileDialog1.ShowDialog();
 sFileName = openFileDialog1.FileName;
 
 if (sFileName.Length!=0)
 {
 oDocument = null;
 webBrowser1.Navigate(sFileName);
 }
 }
 
 private void Form1_Load(object sender, EventArgs e)
 {
 openFileDialog1.Filter = "Office Documents " + " " + "(*.doc, *.xls, *.ppt,*.mdb )|*.doc;*.xls;*.ppt;*.mdb";
 openFileDialog1.FilterIndex = 1;
 
 }
 
 private void webBrowser1_DocumentCompleted(object sender, WebBrowserDocumentCompletedEventArgs e)
 {
 oDocument = webBrowser1.Document;
 
 }
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This tutorial demonstrates one way to create an application that runs without any Forms but still has a GUI presence via an Icon in the System Tray. The magic lies in Inheriting from the ApplicationContext Class and passing that to Application.Ru…
A while ago, I was working on a Windows Forms application and I needed a special label control with reflection (glass) effect to show some titles in a stylish way. I've always enjoyed working with graphics, but it's never too clever to re-invent …
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question