Class Database Connection

class Connection

{

  SslConnection con=new SqlConnection("user id=sa;password=;datasource=");

con.Open();

}

Hi..Friend..

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

Thank you..

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 !!! ~

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.