class DsProducts
    {
        public SqlConnection con { set; get; }
 
        public SqlCommand cmd { set; get; }
 
        public DataSet Ds { set;  get; }
 
        public SqlDataAdapter Da { set; get; }
 
        public DataTable Dt { set;  get; }
 
        private ICollectionView _ICollView;
 
        public ICollectionView ICollView
        {
            set
            {
                _ICollView = value;
            }
 
            get
            {
                return _ICollView;
            }
        }
 
        public  DsProducts()
        {
            Fill();
        }
 
        public void Connection()
        {
            // Verbindung definieren
            con = new SqlConnection();
 
            con.ConnectionString = _
              ConfigurationManager.ConnectionStrings["SQLServer"].ConnectionStr_
              ing;  // Holt den Wert aus App.config
 
 
 
        }
 
        public void Fill()
        {
            if (con == null) Connection();
 
            cmd = new SqlCommand();
            cmd.CommandText = "Select * FROM Products";
 
            cmd.CommandType = CommandType.Text; 
 
            cmd.Connection = con;
 
            if (Ds == null) Ds = new DataSet();
 
            if (Da == null) Da = new SqlDataAdapter();
 
            Da.SelectCommand = cmd;
 
            Da.FillLoadOption = LoadOption.OverwriteChanges;
 
            //Ds.Tables["Products"].Clear();
 
            Da.Fill(Ds, "Products");
 
            if (Dt == null) Dt = Ds.Tables["Products"];
 
            if (_ICollView != null) ICollView.Refresh();
        }
 
 
    }
}