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.