private void CheckAccpet_Click(object sender, EventArgs e) { int err = 0; if (Int32.TryParse(ItemRecievedCode.Text, out err)) //checks for integer input { PartsDBConnector connection = new PartsDBConnector("blitz.cs.niu.edu", 3306, "student", "student"); Part signlePart = connection.GetPartByID(Int32.Parse(ItemRecievedCode.Text)); PartName.Text = signlePart.Name; PartName.Visible = true; } else { PartName.Text = "Error, not valid part"; } //else show error }
static void Main(string[] args) { PartsDBConnector connector = new PartsDBConnector("blitz.cs.niu.edu", 3306, "student", "student"); var parts = connector.GetAllParts(); foreach (var part in parts) { Console.WriteLine(part.ID); Console.WriteLine(part.Name); Console.WriteLine(part.Price); Console.WriteLine("---------------"); } Console.ReadLine(); var part1 = connector.GetPartByID(3); Console.WriteLine(part1.ID); Console.WriteLine(part1.Name); Console.WriteLine(part1.Price); Console.WriteLine("---------------"); Console.ReadLine(); }