How can I create a Class/Method

Tony Tony

Hello,

I have this connection string code below;

string conn = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString.ToString();
            SqlConnection cn;
            cn = new SqlConnection(conn);
            cn.Open();

How can I create a Class/Method to be able to call just a string or variable whenever I need this connection strings on my code page?

I hope my question is clear? Thanks for helping in advance.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ashutosh Gupta6y ago
if i understood your question, you need a way to access connection string from anywhere, is it

you can make use of static keyword.
public class DBContext
{
    private static string  str;
    public static string ConnectionString
    {
          if(string.IsNullOrEmpty(str))
         {
             str = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString.ToString();
         }
         return str;
    }
}
now you should be able to use like DBContext.ConnectionString

i hope that helps
0
Rajanikant Hawaldar6y ago
Hello please refer this article https://www.c-sharpcorner.com/UploadFile/f26fb0/connection-class-in-C-Sharp/ https://forums.asp.net/t/2117016.aspx?how+to+make+a+common+class+for+connection+written+in+c+and+call+that+connection+from+the+common+class+to+simply+ensure+that+connection+is+closed+and+disposed+properly+ Below is class implemented and showed how to use public partial class WebForm56 : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { //-- get connection SqlConnection con = myConnection.GetConnection(); //-- code to do... //-- code to do... . //-- close and dispose the connection myConnection.Dispose(con); } } public class myConnection { //-- code to get a connection object public static SqlConnection GetConnection() { string str = ConfigurationManager.ConnectionStrings["DbConnString"].ConnectionString; SqlConnection con = new SqlConnection(str); con.Open(); return con; } //-- code to make sure to close connection and dispose the object public static void Dispose(SqlConnection con) { if (con.State == System.Data.ConnectionState.Open) con.Close(); con.Dispose(); } }
0