namespace somepackage.MyDataSetTableAdapters
{
    public partial class ClientsTableAdapter
    {
        public void SetCustomConnection(string connectionString)
        {
            System.Data.SqlClient.SqlConnection conn = new   System.Data.SqlClient.SqlConnection();
            conn.ConnectionString = connectionString;
            this.Connection = conn;
        }
    }
}