|
I've never tried to access MySql with OleDb; I've always used the MySql .net connector.
On a MySql database I access at work that doesn't work -- it seems it may be an older version of MySql.
|
|
|
|
|
PMSL... or just
SHOW DATABASES;
oops... or indeed
SHOW TABLES;
edit... why did I think that said show tables the first time I edited, then edit it again to be incorrect to show databases... my excuse is that it was Wednesday...
modified 19-Apr-12 7:56am.
|
|
|
|
|
yes i chenged OLEDB with Mysql and it work
|
|
|
|
|
My mistake. That was a code snippet I once used on Access. I trust the same approach works just fine on MySQL, mutatis mutandis.
|
|
|
|
|
My problem was my mistake as well... the userID I was given only has access to views, so of course they didn't show up when I asked for tables.
|
|
|
|
|
can I use the same function to show the list of databases names?
|
|
|
|
|
Is there a way / workaround to send a HTML formatted EMail using SimpleMapi?
|
|
|
|
|
i am not able to extract human body from webcam image i am using aforge.net.please help me to find this problem.
|
|
|
|
|
The human body is an irregular shape with different colors. You can't simply 'detect something that looks like a body'.
Start with something simpeler, like a blue ball and work from there.
Bastard Programmer from Hell
|
|
|
|
|
Hi all,
I'm creating a specific DataGridView control that includes two scrollbars so that I can control their size and visibility. So, I have created a User control that contains the DataGridView and the two scrollbars inside a 2x2 TableLayoutPanel.
The issue I'm facing is that when I add my control to a Windows Form, I can't set my DataGridView's DataSource or define the column styles from the design view, because the link that I use for that when I use a common DataGridView (that little white arrow appearing on the top right side of the DataGridView) is not appearing.
While doing some testing, I saw that if I inherit my control from DataGridView, that link appears. But if I do that, I guess that I can only extend the functionality for the DataGridView, but I need my control to be a composite control.
So, that's my question: how can I get those design-time capabilities on my custom control? I am specially interested on the columns layout and the datasource.
Best regards.
|
|
|
|
|
I think the reason may be that the smart tag is at control level. When the DataGridView is used on its own, then it is a single control and the smart tag is available on it. Even in the designer surface of the user control, the smart tag may be available as different controls added to the user controls can be accessed separately.
But once the user control is compiled and is used as a control on a form, then the user control along with all nested controls will behave like a single control. Hence, if a smart is provided for the control as a whole then it may be available on the control.
With a similar analogy the properties of different controls comprising the user control can be accessed through the Properties window by clicking on a control in the designer surface of user control. Whereas, after compiling the user control and placing it on a form the properties of the user control only will be available in the Properties window and the properties of individual controls comprising user control cannot be accessed separately in the Properties window.
Hence, I think an option is to provide a smart tag for the user control. In this regard I think the following articles may be helpful.
Customizing User Controls with Smart Tag Feature[^]
How to make a Smart Tag using C#[^]
http://msdn.microsoft.com/en-us/library/ms171829.aspx[^]
|
|
|
|
|
Hi
I need to polulate XMLDatasource using a DataTable.
Can someone asisst please?
Regards
Chindiwo
Chindiwo
Programmer
-----
|
|
|
|
|
Sure, take a look here[^].
Binding 100,000 items to a list box can be just silly regardless of what pattern you are following. Jeremy Likness
|
|
|
|
|
i'm new in C# and i'm a bit curious with something inside Environment Exit.
don't care what number i put inside, it's just the same, so what is it for?
Thanks before
|
|
|
|
|
They invented "documentation", it is quite good at the level of classes and methods.
And if you can't find it right away, a search engine could help you out.
|
|
|
|
|
Luc Pattyn wrote: They invented "documentation"
And Microsoft killed it by eliminating actual manuals, providing us with MSDN in place of useful books.
Will Rogers never met me.
|
|
|
|
|
The only difference between a Microsoft book and MSDN is the binding is missing on MSDN.
|
|
|
|
|
|
+5 for informative link
Happy Coding...
|
|
|
|
|
|
Congratulations! You just gave him a fish instead of teaching him how to catch his own fish.
|
|
|
|
|
It's needless, don't use it.
|
|
|
|
|
PIEBALDconsult wrote:
It's needless, don't use it.
No it isn't.
If one creates a windows service and threads remain running when the service does a normal exit then the service will continue to run requiring one to kill it.
Exit() terminates all threads.
And if one wants to do dynamic batch processing or any other process management processing with executables then Exit() can be used to return information to the caller. This is normally going to be less useful than services but since the only way to truly isolate unmanaged code is in another process it can on rare occassions be useful.
|
|
|
|
|
jschell wrote: and threads remain running when the service does a normal exit
Then you're doing something wrong.
|
|
|
|
|
PIEBALDconsult wrote: Then you're doing something wrong.
Presumably you in not having an correct way to shut down all threads, then I would agree to the extent that I would prefer to have such a method, and at least attempt that in my own code.
But since some of the services I manage deal with disparate code sources (and developers) which might include up to 20 sources I can't insure that.
Exit() however does insure it.
|
|
|
|