PromptDataSource method

[Coder]

When using Delphi, In order to create connection strings, there was a method
to show Data Source creation page,

string ConnStr = PromptDataSource();

What is the C# equivalent of this method ?

Thanks

 

[Bill B]

I don't know of a built-in mechanism to prompt the user for a data
source selection in C#, but you should be able to build your own dialog
and prompt the user for the relavent information and then construct a
connection string.

More details on prompting for UserID/Password and then building the
connection string can be found at:

http://msdn.microsoft.com/library/d...AccessingSQLServerWithExplicitCredentials.asp

Bill

 

[Bill Block]

I don't know of a built-in mechanism to prompt the user for a data
source selection in C#, but you should be able to build your own dialog
and prompt the user for the relavent information and then construct a
connection string.

More details on prompting for UserID/Password and then building the
connection string can be found at:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbco...

Bill

 

[Polaris431]

Add a reference to Microsoft.Data.ConnectionUI. This is located in the
directory where VS is installed, eg:

C:\Program Files\VS8\Common7\IDE\Microsoft.Data.ConnectionUI.dll

Add the following code...

using Microsoft.Data.ConnectionUI;

....

Microsoft.Data.ConnectionUI.DataConnectionDialog dcd = new
Microsoft.Data.ConnectionUI.DataConnectionDialog();

Microsoft.Data.ConnectionUI.DataSource.AddStandardDataSources(dcd);

if (Microsoft.Data.ConnectionUI.DataConnectionDialog.Show(dcd)
== System.Windows.Forms.DialogResult.OK)
{
string buf = "Provider: " + dcd.SelectedDataProvider.Name +
"\r\n" + "ConnectionString: " + dcd.ConnectionString;
}

This is an undocumented method of displaying the same dialog that
VS.NET uses. But what the hack (I mean what the 'heck'). Some features
eventually find their way into a product when enough users use the hack
and Microsoft eventually catches on. This feature really should have
been in the product from day one. You listening MS?

Best Regards
Polaris431