|
Never mind. Found this in a CACHED(!!!) website (thank goodness for Google's caching--the original link is gone).
In Visual Studio Design Environment
Click on the Project Menu
Click on Add Reference
Click on the COM Tab
Select Microsoft DAO 3.6 Object Library
A reference to DAO will be added to your project
The Data Access Objects Library DAO will be accessible in your project using COM Interop
The namespace DAO will be come visible in your project.
To create a database called database.mdb using Access 2000 DAO and C# use the following line of code :
DAO.DBEngineClass Db = new DAO.DBEngineClass();
Db.CreateDatabase("C:\\bin\\dao\\database.mdb",DAO.LanguageConstants.dbLangGeneral,DAO.DatabaseTypeEnum.dbDecrypt);
All happy now. 
Marc
STL, a liability factory - Anonymously
A doable project is one that is small enough to be done quickly and big enough to be interesting - Ken Orr
Latest AAL Article
My blog
|
|
|
|
|
Marc Clifton wrote:
Select Microsoft DAO 3.6 Object Library
Eww, DAO, that so old school. 
-Nick Parker
|
|
|
|
|
By the way, you may wanna use the @ for literal strings that contain backslashes. Then you don't have to escape them:
Db.CreateDatabase(@"C:\bin\dao\database.mdb", ...);
Regards,
Alvaro
Hey! It compiles! Ship it.
|
|
|
|
|
i have 3 forms and a toolbar with 3 buttons.
Form1, Form2, Form3, tbbForm1, tbbForm2, tbbForm3
i want the toolbar buttons to switch between these 3 forms.
the problem i'm having is that each time i press a button, it opens the form in a new window.
private void toolBar1_ButtonClick(object sender, System.Windows.Forms.ToolBarButtonClickEventArgs e)
{
if(e.Button == this.tbbForm1)
{
Form1 frm1 = new Form1();
this.frm1.Show();
}
else if(e.Button == this.tbbForm2)
{
Form2 frm2 = new Form2();
this.frm2.Show();
}
else if(e.Button == this.tbbform3)
{
Form3 frm3 = new Form3();
this.frm3.Show();
}
}[/code]
i know my code calls on a new object each time the button is pressed. i have tried instantiating each of the forms in the constructor so i could just use the Show() method, but this does not work.
please help! =)
|
|
|
|
|
Erm, what happens if you instantiate all three forms, the for each button do something like this:
frm1.Show();
frm2.Hide();
frm3.Hide();
On the other hand, if you're toolbar is doing this, why not instead use a tab control and tab pages?
Marc
STL, a liability factory - Anonymously
A doable project is one that is small enough to be done quickly and big enough to be interesting - Ken Orr
Latest AAL Article
My blog
|
|
|
|
|
mikemilano wrote:
i know my code calls on a new object each time the button is pressed. i have tried instantiating each of the forms in the constructor so i could just use the Show() method, but this does not work.
The reason why is you must first define it like so
<br />
public class Form1<br />
{<br />
<br />
private Form2 fm;<br />
<br />
public Form1()<br />
{<br />
fm = new Form2();<br />
}<br />
<br />
public void Button1_Click( object sender, EventArgs e )<br />
{<br />
fm.Show();<br />
}<br />
}<br />
<br />
thats all there is to it
I'm not an expert yet, but I play one at work. Yeah and here too.
|
|
|
|
|
Pardon my stupidity on this one:
I need to iterate through a dataset that contains one table w/ one row. Essentially I have 5 fields within the table, and each field has to be output to a label or text box. How do I go about doing this?
Ken
|
|
|
|
|
//get the first table in the dataset, first row (if you only have 1 row), get
//the data by fieldName
textBox1.Text = dataSet.Tables[0].Rows[0]["fieldName"].ToString();
textBox2.Text = dataSet.Tables[0].Rows[0]["otherField"].ToString();
I find it easier to use a DataRow...
DataRow row = dataSet.Tables[0].Rows[0];
textBox1.Text = row["fieldName"].ToString();
textBox2.Text = row["otherField"].ToString();
You can also use numerics in the field if the field names are not constant...
textBox1.Text = row[0].ToString();
textBox2.Text = row[1].ToString();
|
|
|
|
|
although its faster to
SqlDataAdapter myAdapter = MySqlCommand.ExecuteReader();
object[] myArrayOfColumns = myAdapter.GetValues();
I'm not an expert yet, but I play one at work. Yeah and here too.
|
|
|
|
|
I need a way to create an activeX at runtime, with nothing more than a CLSID. To put it a different way, I have to be able to create an activeX control without linking to its tlb, similiar to how the ActiveX Control Test Container works.
I used to do this in MFC with the CWnd::CreateControl() function. Is there some C# equivalent to this?
Thanks,
Aaron Stibich
|
|
|
|
|
Do it the same way as you would create a normal WinForms control:
Button button=new Button();
this.Controls.Add(button);
"Blessed are the peacemakers, for they shall be called sons of God." - Jesus
"You must be the change you wish to see in the world." - Mahatma Gandhi
|
|
|
|
|
Wouldn't that require that I've imported the type information for my control (ie. You cannot new a "Button" without having imported the type information for Button)? I need to create and connect to the activeX via late binding methods only.
Aaron
|
|
|
|
|
You can do:
Type type=Type.GetType(classname,false,false);
object control= Activator.CreateInstance(type);
...
But I'd be interested to know if you have to use aximp.exe on the control to create a .NET control wrapper before you can put it on a .NET form.
"Blessed are the peacemakers, for they shall be called sons of God." - Jesus
"You must be the change you wish to see in the world." - Mahatma Gandhi
|
|
|
|
|
I am working on an application which will have the same menu and tool bar in every form.
Does this mean that I should design a 'template' form which has only the menu and tool bar.
Then, each new form ( including the main form ) will inherit this template form?
|
|
|
|
|
Yes, this is one way to do it. 
"Blessed are the peacemakers, for they shall be called sons of God." - Jesus
"You must be the change you wish to see in the world." - Mahatma Gandhi
|
|
|
|
|
|
Hi all,
is there a way to open MS Office documents (word documents, excel spreadsheets, powerpoint presentations) and acrobat PDF files within a Windows Forms application? Is there an ActiveX component or something similar to achieve this? Thanks for any clues in advance!
Rado
|
|
|
|
|
iSEDQuickPDF is 60.00. Load the word 9.0 library, excel 9.0 library
also www.planetpdf.com has a lot but ised is cheap and easy to use
I'm not an expert yet, but I play one at work. Yeah and here too.
|
|
|
|
|
Ista wrote:
iSEDQuickPDF is 60.00
Well, I am not interested in manipulating or generating PDF files, I just want to view them in my application and needed a clue, something where to start and what to look for. But anyway thanks a lot for the info, iSEDQuickPDF looks good and I may use it in future.
Rado
|
|
|
|
|
Okay so I get back monday after a power flicker. I had to rebuild my solution with 6 different projects inside. One of them dispatcher. When I set a breakpoint it tells me I dont have symbols loaded. I specified the main folder in the debug symbols dialog and it still wont let me at it.
Please help me dude
I'm not an expert yet, but I play one at work. Yeah and here too.
|
|
|
|
|
nvm, the VS.NET IDE really bites as far as debugging reliability is concerned
I'm not an expert yet, but I play one at work. Yeah and here too.
|
|
|
|
|
Hello, I have a c# assembly that gets called by unmanaged code (it gets called by Internet Explorer, like a plugin).
What I want to know is, how do I get the thread ID of the current thread? If I use System.Threading.Thread.CurrentThread, I can only get the name. As I understand it, C# threads are not the same thing as old win32 threads. But since my C# assembly is being called by unmanaged code, it is definately running on one of those win32 threads, how do I get the thread ID?
thank you
"Outside of a dog, a book is Man’s best friend. And inside of a dog, it’s too dark to read."
-Groucho Marx
|
|
|
|
|
Have you tried the GetCurrentThreadID() API? I know it's best to stick with the managed versions of the Win32 APIs, but this might give you what you want with no ill affects.
|
|
|
|
|
Well Thread.GetHashCode Will but as you guessed its a managed thread ID which isnt a win32 id because really it runs in appDomains and other factors. The key word is managed AKA hosted
<br />
Note An operating-system ThreadId has no fixed relationship to a managed thread, because an unmanaged host can control the relationship between managed and unmanaged threads. Specifically, a sophisticated host can use the fiber API to schedule many managed threads against the same operating system thread, or to move a managed thread between different operating system threads.<br />
hope this helps
I'm not an expert yet, but I play one at work. Yeah and here too.
|
|
|
|
|
Also SYstem.AppDomain.GetCurrentThreadID
I'm not an expert yet, but I play one at work. Yeah and here too.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
