|
Hi, I am creating a database, and on the first form I want a listbox displaying the names of all the tables, so when a user clicks on one and clicks the OK button, it will open another form showing the data in that table.
What I need to know is how to get the names of the tables in the database without hard coding it.
Thanks in advance,
Any reply is appreciated.
|
|
|
|
|
Hi,
have a look at the GetSchema[^] on your connection class. I think it doesn't work on every database and it's also not very comfortable to get the results out of the returned DataTable but it worked for me when wokring with Access databases.
Robert
|
|
|
|
|
Well, it would help if you mentioned which database you are working with. I can help you with oracle:
for all tables:
'select table_name from dba_tables;'
for tables for a specific owner:
'select table_name from dba_tables
where owner = 'XYZ';'
for all the tables you have access to:
'select table_name from all_tables';
based on the result you may fill the listbox !
hope this helps
regards,
Noman Nadeem 
|
|
|
|
|
How do I programmatically minimize a Form? (I also want to restore the size programmatically).
I'm using VS2003 .NET 1.1.
|
|
|
|
|
Use the WindowState property of your form. The size can be adjusted using the Size property, surprisingly... 
Regards,
mav
--
Black holes are the places where God divided by 0...
|
|
|
|
|
|
I have a thread running that needs to read the Windows Clipboard but my Clipboard.GetDataObject() always returns null. I've read that Clipboard.GetDataObject() doesn't work in a thread (even though it's supposed to be thread safe), so I tried setting the apartment state by doing Thread.SetApartmentState(ApartmentState.STA) and still no luck. Anyone have any ideas I can try? The Main() function is declared with [STAThread] and I've even tried using [STAThread] to declare the function that tries to read the clipboard.
Here's the background on the thread:
The thread imports data from various formats (Excel, CSV, DBF, MDB, and I"m trying to get Word working) into a database. The best way I've seen to read Word Docs is to open the doc by creating a Word Application class, opening the doc in question, having word select severything and copy it to the clipboard.
I'm running WinXP pro and Word 2007 (wasn't having much luck in the previous version of Word either)
Here's the code that I use to call the thread:
m_ProcessThread = new Thread(new ParameterizedThreadStart(this.RunJob));<br />
m_ProcessThread.SetApartmentState(ApartmentState.STA);<br />
m_ProcessThread.Start(NextUp);<br />
m_JobList.Sort();<br />
m_JobList.ResetNextUp();<br />
UpdateJobListView();
And here's my clipboard reader (straight from MSDN)
IDataObject iData = Clipboard.GetDataObject();
Thanks!
|
|
|
|
|
I'm not really sure what you've read, but the only thing that could make sense is that it only works in a UI thread ("doesn't work in a thread" - every piece of code that's being executed is run in a thread...).
If everything else fails and you're still convinced the threading is the culprit you could try marshalling all calls to Clipboard.GetDataObject() to the UI thread... (using Invoke() or BeginInvoke()).
Regards,
mav
--
Black holes are the places where God divided by 0...
|
|
|
|
|
You know, I really really should've thought of calling from the UI thread myself...
I'll give it a shot, I'm sure it'll work.
Thank you very much!
|
|
|
|
|
Can C# create dynamic hashes and arrays in a similar fashion to perl (i.e. in perl you can statically define almost any structure your mind can imagine)?
For example an array of variable length arrays (pseudo code):
<br />
arrays = <br />
{<br />
{1},<br />
{1, 2},<br />
{3, 2, 1},<br />
undef,<br />
{5, 6, 7, 8, 9},<br />
}<br />
Todd Smith
|
|
|
|
|
|
edboe wrote: Have you tried it?
Nice!
led mike
|
|
|
|
|
Your code in C#
object[] arrays =
new object[]
{
new object[] {1},
new object[] {1,2},
new object[] {3,2,1},
null,
new object[] {5,6,7,8}
};
|
|
|
|
|
Even though I have a feeling that I'm doing someone's homework, I think it would be more like this:
Nullable<int>[][] arrays = new Nullable<int>[][]
{
new Nullable<int>[] {100},
new Nullable<int>[] {1,2},
new Nullable<int>[] {3,2,1},
null,
new Nullable<int>[] {5,6,7,8}
};
|
|
|
|
|
I'm trying to find a good HTML editor control for my Windows Forms application. The control must not use the IE COM and ActiveX components, and should have source available, ideally in C#.
|
|
|
|
|
SyncFusion have an editor control (I think), it's either a viewer or editor/viewer can't remember which. And I think it has source code available.
Sorry if it doesn't do the job but I just remember coming across it a while ago.
|
|
|
|
|
My colleague downloaded their EssentialEdit and EssentialHTMLUI, and I will be looking at them when he gets it, but I've found that the problem with most html controls is that they wrap MSHTML or one of the other IE browser interfaces, eliminating the Mac as a target platform.
So far I'm starting to think about using an HTML rendering control (like EssentialHTMLUI) and extending it by providing my own editing functions.
|
|
|
|
|
I don't think you'll find many that aren't based on MSHTML or Gecko because it's a hell of a lot of code to write to support various pages, e.g. those which don't conform etc. You might be able to find one which only supports XHTML for example since at least that should be standards compliant.
|
|
|
|
|
I have started looking at using the Mozilla tools on both platforms, but I think that will be some work.
|
|
|
|
|
How extensive do you need the editor to be, i.e. support all forms or is it just going to be using a subset of HTML?
|
|
|
|
|
No, it only has to support enough HTML to allow the user to create documents, i.e. all normal formatting including table editing etc. and maybe some styles.
|
|
|
|
|
There's a RichTextBox control here (on CP) which supports some of this but will save it's output to HTML. Very basic but allows pictures, tables etc and I think supported some styles.
If I come across it again I'll let you know.
|
|
|
|
|
Hi,
I am working an application window program using .Net Framework SDK 2.0 but I having a problem that after I compile with the SDK 2.0, as I run the program, there are 2 windows appears together which are the blank console window and my desired application window.
Problem is when closing the console window, the application closes. But I still want the application window.
How to code it? Help Me...
|
|
|
|
|
I think you should change the way you comple ur code using csc.exe
you will be compiling ur code using
csc /target:exe yourfile.cs
You need to change ur command line option like,
csc /target:winexe yourfile.cs
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
