How can I create a Class/Method

Question

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.

Ashutosh Gupta · Answer

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

Rajanikant Hawaldar · Answer

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(); } }