public Form1() { InitializeComponent(); connection = new PartsDBConnector("blitz.cs.niu.edu", 3306, "student", "student"); allParts = connection.GetAllParts(); partListBox.DataSource = allParts; }
// GET: Order public ActionResult Index() { var connection = new PartsDBConnector("blitz.cs.niu.edu", 3306, "student", "student"); var allParts = connection.GetAllParts(); foreach (Part p in allParts) { orders.Add(new OrderModel(0, p)); } return(View(orders)); }
protected void Page_Load(object sender, EventArgs e) { var connection = new PartsDBConnector("blitz.cs.niu.edu", 3306, "student", "student"); orderRows = new List <OrderRow>(); allParts = connection.GetAllParts(); foreach (Part p in allParts) { orderRows.Add(new OrderRow(0, p)); } GridView1.DataSource = orderRows; GridView1.DataBind(); }
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(); }