Class Database Connection

Question

Hillo, Since im new in C#.net will you please help me.. i want to put my database connection to a class.. but isnt work..please help me.. thanks.

Satyanarayan Bajoria · Answer

class Connection { SslConnection con=new SqlConnection("user id=sa;password= ;datasource= "); con.Open(); }

Therese Puno · Answer

Hi..Friend.. Thank you very much...the code sample now its really work.. Thank you..

Dinusha Gamage · Answer

Hi Friend, The given below coding is used to create the DB connection class. I think you know how to get the connectionstring . // This should be created in a namesapce public class Connection { public string SetConnection() { string connectionstring = "Data Source=LOCALSERVER;Initial Catalog=ACME_ERP;Integrated Security=True" ; return connectionstring; } } After that you can create a object from that class and call the SetConnection() method as given below: public Connection conObject = new Connection (); SqlConnection scon = new SqlConnection (conObject.SetConnection()); Does that do what you want? ~ Happy Coding !!! ~

Jan Montano · Answer

Hi Therese, please post what you have so far. pls post the code that isn't working and what result you expect to achieve with the code. thanks.

Class Database Connection

Answers (4)