Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsFree MagazinesWhite PapersSubmit Content
Discussion GroupsASP.NETWindows FormsLanguages.NET FrameworkVisual Studio.NET
Articles.NET FrameworkASP.NETToolsWindows Forms
.NET DirectoryOpen Source ProjectsUser GroupsWeb Resources
Related Topics
Visual Basic 6SQL ServerMS AccessOther DB ProductsMS Server ProductsMore Topics ...

.NET Forum / Visual Studio.NET / Extensibility / September 2006

Tip: Looking for answers? Try searching our database.

DDEX - Data Connections

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Kishore - 11 Jul 2006 17:31 GMT
I have written a Data Provider by extending DDEX and registered it with the
VS.NET. However when I close the connection, the red cross mark does not
appear on the item (in the server explorer tree control). This works with
the SQL Server Provider. What do I need to do to show this red cross mark
(icon)?
Any help will be appreciated.

-K
Robert Simpson - 13 Jul 2006 04:04 GMT
Are you raising StateChanged events on your connection?

>I have written a Data Provider by extending DDEX and registered it with the
> VS.NET. However when I close the connection, the red cross mark does not
[quoted text clipped - 4 lines]
>
> -K
Kishore - 14 Jul 2006 18:48 GMT
Thanks Robert.

Raising the event in the close() method of my ado.net connection object
solved this issue.

Regards,
Kishore

> Are you raising StateChanged events on your connection?
>
[quoted text clipped - 7 lines]
>>
>> -K
Michael Kanios - 14 Sep 2006 16:33 GMT
Hi,

I was wondering if you were able to find an Editor to the CommandText
property. I really like the Microsoft one (Query builder) and I can't find
the library for it.

Thanks in advance

>I have written a Data Provider by extending DDEX and registered it with the
> VS.NET. However when I close the connection, the red cross mark does not
[quoted text clipped - 4 lines]
>
> -K
Robert Simpson - 14 Sep 2006 17:54 GMT
Go download my SQLite ADO.NET 2.0 data provider at:

http://sqlite.phxsoftware.com

It uses Microsoft's query builder to edit the CommandText property among
lots of other designer things.  It's also open source so you can peek under
the hood.  Be warned though, in order to use Query Builder, you'll need to
have a fully-functional GetSchema() method on your Connection object.

Robert

> Hi,
>
[quoted text clipped - 13 lines]
>>
>> -K
Michael Kanios - 16 Sep 2006 12:35 GMT
Worked like a charm. Thanks.
I have another question though.
I managed to get DDEX support but at the configure tableadapter wizard the
"refresh the data table" option is disabled. My command object supports
subqueries and I don't know if I'm missing something.

Michael

> Go download my SQLite ADO.NET 2.0 data provider at:
>
[quoted text clipped - 26 lines]
>>>
>>> -K
Robert Simpson - 18 Sep 2006 18:01 GMT
There are ways to enable to that button, but it doesn't work with 3rd party
providers.  I'm pretty sure the implementation of it is hardcoded for the MS
providers.

Robert

> Worked like a charm. Thanks.
> I have another question though.
[quoted text clipped - 35 lines]
>>>>
>>>> -K
Michael Kanios - 18 Sep 2006 19:13 GMT
This is enabled in SQLite provider but I was not able to figure out why.
Unfortunately the documentation of Visual Studio SDK is pure.
I thought it was something in MySqlDataObjectSupport.xml but again I could
not gigure it out.
Thanks anyway Robert.

Michael

> There are ways to enable to that button, but it doesn't work with 3rd
> party providers.  I'm pretty sure the implementation of it is hardcoded
[quoted text clipped - 41 lines]
>>>>>
>>>>> -K
Michael Kanios - 24 Sep 2006 19:32 GMT
Hi Robert,

I found thread in your forum where you indicate that you were able to solve
the problem with the "refresh the data table option" in SQLite data
provider.
I'm trying to provide this functionality in MySql .Net data provider with no
luck.
I would really aprecieate any help.

You original post:
http://sqlite.phxsoftware.com/forums/637/ShowPost.aspx

Thanks

Micahel

> This is enabled in SQLite provider but I was not able to figure out why.
> Unfortunately the documentation of Visual Studio SDK is pure.
[quoted text clipped - 49 lines]
>>>>>>
>>>>>> -K
Robert Simpson - 25 Sep 2006 17:35 GMT
I replied in e-mail but will repost here just in case anyone else is
wondering ...

Essentially that feature is hard-coded in VS2005 around the MS providers.
It is possible to get the checkbox to un-grey, but that's pretty much all
you can contribute to the wizard.  The code generation process that
implements that option has no hooks to allow you to implement the feature in
your provider.

My suggestion on the issue from back in March:
https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID
=123835


Robert

> Hi Robert,
>
[quoted text clipped - 67 lines]
>>>>>>>
>>>>>>> -K

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.