• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 347
  • Last Modified:

How to embed MS Access table in .net form

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
rishaan
Asked:
rishaan
  • 4
  • 4
1 Solution
 
CodeCruiserCommented:
Not sure what you mean.
0
 
rishaanAuthor Commented:
Access table is very powerful with all the filter capability. I want to show that table on a .net form.
0
 
CodeCruiserCommented:
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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
CodeCruiserCommented:
0
 
rishaanAuthor Commented:
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
 
CodeCruiserCommented:
Yes. Give it a try.
0
 
rishaanAuthor Commented:
       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
 
rishaanAuthor Commented:
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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now