private void PopulateGrids() { //special offer SpecialOffer so = new SpecialOffer(); try { DataSet ds = new DataSet(); ds = so.GetAllSpecialOffersDataSet(); dgSpecialOffers.DataSource = ds.Tables[0]; dgSpecialOffers.Columns["specialofferid"].HeaderText = "ID"; dgSpecialOffers.Columns["specialofferid"].Width = 60; dgSpecialOffers.Columns["description"].Width = 250; dgSpecialOffers.Columns["type"].Width = 40; dgSpecialOffers.Columns["startdate"].Width = 150; dgSpecialOffers.Columns["enddate"].Width = 150; dgSpecialOffers.Columns["startdate"].HeaderText = "Start Date/Time"; dgSpecialOffers.Columns["enddate"].HeaderText = "End Date/Time"; dgSpecialOffers.Columns["MinQty"].Width = 70; dgSpecialOffers.Columns["MaxQty"].Width = 70; dgSpecialOffers.Columns["modifieddate"].Visible = false; //dgSpecialOffers.Columns[ } catch (Exception ex) { MessageBox.Show(ex.Message, "MICS", MessageBoxButtons.OK, MessageBoxIcon.Information); } finally { so = null; } }