private void Form1_Load(object sender, EventArgs e) { // TODO: This line of code loads data into the 'shapesDBDataSet.ShapeTypes' table. You can move, or remove it, as needed. this.shapeTypesTableAdapter.Fill(this.shapesDBDataSet.ShapeTypes); var db = new ShapesDBDataContext(); var shapes = db.Shapes; var shapesList = new List <ShapeClass>(); foreach (var shape in shapes) { switch (shape.ShapeTypeId) { case (int)EnumShapeTypes.Square: shapesList.Add(new Square(shape.Name, shape.A ?? default(double))); break; case (int)EnumShapeTypes.Rectangle: shapesList.Add(new Rectangle(shape.Name, shape.A ?? default(double), shape.B ?? default(double))); break; case (int)EnumShapeTypes.RightTriangle: shapesList.Add(new RightTriangle(shape.Name, shape.A ?? default(double), shape.B ?? default(double))); break; case (int)EnumShapeTypes.Circle: shapesList.Add(new Circle(shape.Name, shape.R ?? default(double))); break; } } listBox1.DataSource = shapesList; listBox1.DisplayMember = "ShapeName"; }
private void button1_Click(object sender, EventArgs e) { //Insert shape var shapeTypeId = int.Parse(comboBox1.SelectedValue.ToString()); var shapeName = textBox1.Text; var shape = new Shape { ShapeTypeId = shapeTypeId, Name = shapeName, }; switch (shapeTypeId) { case (int)EnumShapeTypes.Square: shape.A = double.Parse(textBox2.Text); break; case (int)EnumShapeTypes.Rectangle: case (int)EnumShapeTypes.RightTriangle: shape.A = double.Parse(textBox2.Text); shape.B = double.Parse(textBox3.Text); break; case (int)EnumShapeTypes.Circle: shape.R = double.Parse(textBox2.Text); break; } var db = new ShapesDBDataContext(); db.Shapes.InsertOnSubmit(shape); db.SubmitChanges(); //-----// //Refresh data of the form var shapesList = new List <ShapeClass>(); textBox1.Clear(); textBox2.Clear(); textBox3.Clear(); foreach (var item in db.Shapes) { switch (item.ShapeTypeId) { case (int)EnumShapeTypes.Square: shapesList.Add(new Square(item.Name, item.A ?? default(double))); break; case (int)EnumShapeTypes.Rectangle: shapesList.Add(new Rectangle(item.Name, item.A ?? default(double), item.B ?? default(double))); break; case (int)EnumShapeTypes.RightTriangle: shapesList.Add(new RightTriangle(item.Name, item.A ?? default(double), item.B ?? default(double))); break; case (int)EnumShapeTypes.Circle: shapesList.Add(new Circle(item.Name, item.R ?? default(double))); break; } } listBox1.DataSource = shapesList; listBox1.DisplayMember = "ShapeName"; //------// }