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();
}