//Method one
using System.Data.SqlClient;
class myConnection
{
public static SqlConnection GetConnection()
{
string str = "Data Source=MANOZ\\SQLEXPRESS;Initial Catalog=softworksbd;Integrated Security=True;";
SqlConnection con = new SqlConnection(str);
con.Open();
return con;
}
}