Data Link Dialog Box???
-
Hi all, Does anyone how to bring up the DataLink Properties Dialog for editing a connection string, like under the properties of a OleDbConnection? Thanx in advance :) READ MSDN
leppie wrote: Does anyone how to bring up the DataLink Properties Dialog for editing a connection string, like under the properties of a OleDbConnection? Not quite sure what you are asking. If you just want to modify the connection in a Wizard form, you can righ click on the connection you used in the Server Explorer and select Modify Connection. Rocky Moore
-
Hi all, Does anyone how to bring up the DataLink Properties Dialog for editing a connection string, like under the properties of a OleDbConnection? Thanx in advance :) READ MSDN
Code: MSDASC.DataLinks dl = new MSDASC.DataLinks(); dl.PromptNew(); You can find the whole information on msdn : http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlmag2k/html/LinkAPI.asp In C# project, you should add a com reference named : Microsoft OLE DB Service Component 1.0 Type Library Good luck! :rolleyes: I'm amumu, and you?
-
Code: MSDASC.DataLinks dl = new MSDASC.DataLinks(); dl.PromptNew(); You can find the whole information on msdn : http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlmag2k/html/LinkAPI.asp In C# project, you should add a com reference named : Microsoft OLE DB Service Component 1.0 Type Library Good luck! :rolleyes: I'm amumu, and you?
-
Thx :), exactly what I need, but how does one "cast" the returned object to an OleDbConnection? or a ConnectionString? I presume I will need to implement a UITypeEditor as well as I need to show the property through a property grid. :) READ MSDN
MSDASC.DataLinks dl = new MSDASC.DataLinks(); ADODB.Connection connection = dl.PromptNew() as ADODB.Connection; if( null != connection ) MessageBox.Show( connection.ConnectionString ); You should add reference "Microsoft OLE DB Service Component 1.0 Type Library" and the "Microsoft ActiveX Data Objects 2.5 Library" to your project's reference.:rolleyes: I'm amumu, and you?
-
MSDASC.DataLinks dl = new MSDASC.DataLinks(); ADODB.Connection connection = dl.PromptNew() as ADODB.Connection; if( null != connection ) MessageBox.Show( connection.ConnectionString ); You should add reference "Microsoft OLE DB Service Component 1.0 Type Library" and the "Microsoft ActiveX Data Objects 2.5 Library" to your project's reference.:rolleyes: I'm amumu, and you?
Hi and thx :) qf0421 wrote: MSDASC.DataLinks dl = new MSDASC.DataLinks(); ADODB.Connection connection = dl.PromptNew() as ADODB.Connection; then as I'm using OleDb:
OldDbConnection conn = new OleDbConnection(connection.ConnectionString);? Cant test now but it should work. It just seems a bit over the top for such a "small" thing. Another question, if you want to run this on another machine, do u need to register both dll's on the other PC or is the Interop.*.dll files ok for that? :) READ MSDN -
Hi and thx :) qf0421 wrote: MSDASC.DataLinks dl = new MSDASC.DataLinks(); ADODB.Connection connection = dl.PromptNew() as ADODB.Connection; then as I'm using OleDb:
OldDbConnection conn = new OleDbConnection(connection.ConnectionString);? Cant test now but it should work. It just seems a bit over the top for such a "small" thing. Another question, if you want to run this on another machine, do u need to register both dll's on the other PC or is the Interop.*.dll files ok for that? :) READ MSDNI think all dlls you refered are running at local machine, and two support remoting: web service and system.remoting, right? I'm not sure about it.:| And also you can notice if you add a reference, vs.net will copy the file to your bin directory, does it means dll will be invoked local? I'm amumu, and you?