---
title: "how i'm going to include connection file in vb.net?"  
description: "how i'm going to include connection file in vb.net?"  
author: "Manoj Bhatt"  
published: 2013-06-11  
updated: 2013-06-12  
canonical: https://www.mindstick.com/forum/1023/how-i-m-going-to-include-connection-file-in-vb-dot-net  
category: "vb.net"  
tags: ["vb.net"]  
reading_time: 1 minute  

---

# how i'm going to include connection file in vb.net?

Hi Expert,\
I'm using [vb.net](https://www.mindstick.com/forum/426/sqlsever-2000-in-network-with-vb-dot-net-2008) and oracle. this is my code connection with db\
I want to establish [connection string](https://www.mindstick.com/articles/328/connection-strings) in VB.NET with [Oracle database](https://www.mindstick.com/articles/13115/types-of-keys-in-sql-or-oracle-database) as following \
Dim connectionString As String = "[Data Source](https://www.mindstick.com/interview/808/what-is-a-data-source) = abc; User ID = abc; [Password](https://www.mindstick.com/blog/118/retriving-user-password-by-using-stored-procedure-in-asp-dot-net) = abc;"Dim [sqlConnection](https://www.mindstick.com/forum/1209/sqlconnection-sqlcommand-sqldatareader-idisposable) As OracleClient.OracleConnection = New OracleClient.OracleConnection(connectionString)\
It's work fine, but when I put connection string into apps.config, that's not working. My line of code as following\
<add key="abc_connection" value="server=xyz;User ID=abc;Password=abc;database=abc;[Connection Timeout](https://www.mindstick.com/forum/1621/connection-timeout-in-urlconnection-using-java)=0"/>\
what line of code I should use for replacing my code connection above ? so that i can call the apps.config file instead of using the code connection repeatedly.\
Thanks in advance.

## Replies

### Reply by AVADHESH PATEL

Hi Manoj,\
You can create a class with settings and add a property\

```
web config<connectionStrings><add name="connectionstring" connectionString="server=xyz;UserID=abc;Password=abc;database=abc;Connection Timeout=0" />
```

**\****cs code**\

```
    public static string connStr    { get { return ConfigurationManager.ConnectionStrings["abc_connection"].ConnectionString; } }if you want to use key in appconfig public static string abc_connection    { get {return  ConfigurationManager.AppSettings["abc_connection"].ToString(); } }
```

**in vb****\**

```
  Public Shared Function connStr() As String    Return ConfigurationManager.ConnectionStrings("abc_connection").ConnectionString ''End FunctionPublic Shared Function abc_connection() As String    Return ConfigurationManager.AppSettings("abc_connection") ''End Function
```


---

Original Source: https://www.mindstick.com/forum/1023/how-i-m-going-to-include-connection-file-in-vb-dot-net

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.