private void button2_Click(object sender, EventArgs e)
{
using (GenericDBMS gd = DataFactory.GetGUI("brock", "passw0rd!", true)) {
_ds = gd.GetViewIV("Zea.Ames.GH.2006.SPR");
}
bindDataGrid(_ds.Tables["viewiv"]);
}
//private void btnSecUser_Click(object sender, EventArgs e) {
// SecUser su = new SecUser();
// MessageBox.Show(su.GenerateCreateSql());
//}
//private void btnInspectSecUser_Click(object sender, EventArgs e) {
// string[] files = GrinGlobal.Core.DatabaseGenerator.TableBase.GenerateClassFiles("prod", "sec_user");
// MessageBox.Show(String.Join(", ", files));
//}
private void btnSearch_Click(object sender, EventArgs e)
{
using (GenericDBMS gd = DataFactory.GetGUI("brock", "passw0rd!", true)) {
_ds = gd.Search(txtSearch.Text);
}
bindDataGrid(_ds.Tables["query"]);
}
private void btnCountryToggle_Click(object sender, EventArgs e)
{
using (GenericDBMS gd = DataFactory.GetGUI("brock", "passw0rd!", true)) {
_ds = gd.ChangeLanguage("DEU");
}
bindDataGrid(_ds.Tables["nonexistent"]);
}
private void btnFill_Click(object sender, EventArgs e)
{
using (GenericDBMS gd = DataFactory.GetGUI("brock", "passw0rd!", true)) {
_ds = gd.GetInventory("Zea.Ames.GH.2006.SPR");
}
DataTable dt = _ds.Tables["iv"];
bindDataGrid(_ds.Tables["iv"]);
}
private void btnFill2_Click(object sender, EventArgs e)
{
using (GenericDBMS gd = DataFactory.GetGUI("brock", "passw0rd!", true)) {
// _ds = gd.GetInventoryAndAccession("Zea.Ames.GH.2006.SPR");
Dictionary <string, object> dic = new Dictionary <string, object>();
dic[":groupname"] = "Zea.Ames.GH.2006.SPR";
_ds = gd.GetData("iv_and_acc", dic, 0);
}
bindDataGrid(_ds.Tables["iv_and_acc"]);
}
private void btnSave_Click(object sender, EventArgs e)
{
using (GenericDBMS gd = DataFactory.GetGUI("brock", "passw0rd!", true)){
_ds = gd.SaveDataSet(_ds);
}
DataTable src = null;
foreach (DataTable dt in _ds.Tables)
{
if (dt.TableName != "ExceptionTable")
{
src = dt;
break;
}
}
bindDataGrid(src);
}
