Populate Treeview with all tables and columns of a database from dataset

Question

I am new in VB. I need to load the tables and columns of a database into a windows form treeview. I know how to bring the information back as a dataset but all the stuff online doesn't show how to load all the tables in a database(as parent) and all the columns (as child) in the the treeview as a dataset.  I have to allow the person to build their SQL statment from the things they select in the treeview. I can't get the treeview working, let alone trying to work on the rest.

Answer 1

Not sure where your post has gone on this but, if you need to control the 3rd party application depending on the selection of some specification on the form, then the easiest way to do it would be to pass the application command line arguments if it's been written to accept them.

You can pass the arguments in the Process.Start method. For example:

   string arguments = "1 abc"; // separate arguments by spaces

   System.Diagnostics.Process.Start("someapp.exe", arguments);

If  the application doesn't accept command line arguments, then you might be able to use SendKeys.Send to send it some keystrokes - for example to open a menu and select an option. This isn't as easy as it sounds since there may be synchronization difficulties and you may need to build in delays between sending the keystrokes to overcome these. Check out the MSDN docs here:

http://msdn.microsoft.com/en-us/library/system.windows.forms.sendkeys.send.aspx 

Answer 2

Well, what's usually done is to put a button on the form, which when pressed, launches the external application:

private button1_Click(object sender, EventArgs e)

{

   System.Diagnostics.Process.Start("someapp.exe");

}

If you wanted the form to display and then the external application to launch automatically, you could do it by handling the form's Shown event:

private void Form1_Shown(object sender, EventArgs e)

{

   System.Diagnostics.Process.Start("someapp.exe");

}