How to convert string to database connection variable

how to convert string to database connection variable

Hi @Aditya10989

To convert a string to a database connection variable in UiPath, you can use the Assign activity to create a new instance of the database connection variable and assign the appropriate values. Here’s an example of how you can achieve this:

  1. First, make sure you have the necessary activities available by including the UiPath.Database.Activities package in your project. You can do this by going to the “Manage Packages” section in UiPath Studio.

  2. Create a string variable, let’s call it connectionString, and assign your database connection string to it.

  3. Create a database connection variable, let’s call it dbConnection, of the appropriate database type. For example, if you’re connecting to SQL Server, you can use the SqlConnection type.

  4. Use the Assign activity to convert the string to the database connection variable. In the activity properties, do the following:

    • Set the “To” field to dbConnection.
    • In the “Value” field, create a new instance of the database connection variable using the appropriate connection type constructor. Pass the connectionString variable as an argument to the constructor.

    For example, if you’re connecting to SQL Server using SqlConnection, the expression in the “Value” field would be:
    New SqlConnection(connectionString)

  5. You can now use the dbConnection variable in subsequent database-related activities, such as executing queries or retrieving data.

Here’s a sample workflow to illustrate the steps described above:

Variables:

  • connectionString (String)
  • dbConnection (SqlConnection)

Assign activity:

  • To: dbConnection
  • Value: New SqlConnection(connectionString)

Remember to replace SqlConnection with the appropriate connection type if you’re using a different database.

Hope it helps!!

@mkankatala I am able to see by using sqlconnection.sqlconnection
image

Looks like Duplicate of: