locked
delphi prism connection string RRS feed

  • Question

  • How to write a connection string in prism (Delphi prism)
    Wednesday, December 9, 2015 7:17 AM

Answers

  • This doesn't seem to be a wpf question.

    .

    By connection string I assume you mean ado.net database connection.

    Since you're making a call on a .net framework method I don't see how it's likely to be any different from the string you would use with vb, c# or whatever.

    The specific string is going to depend on what sort of database but you can look up example connection strings in several places on the web.

    eg

    http://www.connectionstrings.com/


    Hope that helps.

    Technet articles: WPF: Layout Lab; All my Technet Articles

    Wednesday, December 9, 2015 8:26 AM
  • Delphi Prism is a .NET language based upon Delphi. There is an example of how to build a WPF application using this language available at the CodeProject for anyone that reads this thread and is interested: http://www.codeproject.com/Articles/37410/Introduction-to-Delphi-Prism

    When it comes the connection strings, there is no difference as Andy suggests. Delphi is a programming language rather than a database system so how to connect to your database and how the connection string should look like depends on what kind of database system you are using, e.g. SQL Server, Oracle, MySql, etc.

    The link Andy provided gives you examples of connection string to almost all different kind of database management systems.

    If you are asking on how to create a connection string programmatically, you could use the SqlConnectionString builder class the same way you would use any other .NET Framework class in Delphi Prism: https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnectionstringbuilder(v=vs.110).aspx

    If you have any Deplhi programming related questions, I suggest you ask them in the following forums for better help: https://www.delphiforums.com/

    Hope that helps.

    Please remember to close your threads by marking all helpful posts as answer and then start a new thread if you have a new question. Please don't ask several questions in the same thread.

    • Marked as answer by Xavier Xie-MSFT Wednesday, December 23, 2015 11:21 AM
    Wednesday, December 9, 2015 3:18 PM

All replies

  • This doesn't seem to be a wpf question.

    .

    By connection string I assume you mean ado.net database connection.

    Since you're making a call on a .net framework method I don't see how it's likely to be any different from the string you would use with vb, c# or whatever.

    The specific string is going to depend on what sort of database but you can look up example connection strings in several places on the web.

    eg

    http://www.connectionstrings.com/


    Hope that helps.

    Technet articles: WPF: Layout Lab; All my Technet Articles

    Wednesday, December 9, 2015 8:26 AM
  • Delphi Prism is a .NET language based upon Delphi. There is an example of how to build a WPF application using this language available at the CodeProject for anyone that reads this thread and is interested: http://www.codeproject.com/Articles/37410/Introduction-to-Delphi-Prism

    When it comes the connection strings, there is no difference as Andy suggests. Delphi is a programming language rather than a database system so how to connect to your database and how the connection string should look like depends on what kind of database system you are using, e.g. SQL Server, Oracle, MySql, etc.

    The link Andy provided gives you examples of connection string to almost all different kind of database management systems.

    If you are asking on how to create a connection string programmatically, you could use the SqlConnectionString builder class the same way you would use any other .NET Framework class in Delphi Prism: https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnectionstringbuilder(v=vs.110).aspx

    If you have any Deplhi programming related questions, I suggest you ask them in the following forums for better help: https://www.delphiforums.com/

    Hope that helps.

    Please remember to close your threads by marking all helpful posts as answer and then start a new thread if you have a new question. Please don't ask several questions in the same thread.

    • Marked as answer by Xavier Xie-MSFT Wednesday, December 23, 2015 11:21 AM
    Wednesday, December 9, 2015 3:18 PM