/// <summary> /// 테이블 기본값 입력 /// </summary> void InitGridData() { MySqlManage crud = new MySqlManage(ConfigurationManager.ConnectionStrings["MySQL"].ConnectionString); string query = "select MST04SNO, MST04DON, MST04HNO from amr_mst04"; DataSet ds = new DataSet(); ds = crud.SelectMariaDBTable(crud.Connection, query); foreach (DataRow row in ds.Tables[0].Rows) { mDataTable.Rows.Add(row[0], DateTime.Now.ToString("yyyy-MM-dd hh"), row[1], row[2], "null", "null", "null", "null", "null", "null", "null"); mCommTable.Rows.Add(row[0], DateTime.Now.ToString("yyyy-MM-dd hh"), row[1], row[2], "null", "null", "null", "null", "null", "null", "null"); } }
void CurrentForm_Onload(object sender, EventArgs e) { MySqlManage crud = new MySqlManage(ConfigurationManager.ConnectionStrings["MySQL"].ConnectionString); string query = "select MST04SNO, MST04CMP, MST04DON, MST04HNO from amr_mst04"; DataSet ds = new DataSet(); ds = crud.SelectMariaDBTable(crud.Connection, query); AMR_MST04Model model = new AMR_MST04Model(); model.DataTable = ds.Tables[0]; CurrentForm.LoadComplete(model); }
protected internal override void ButtonClick(string tag) { switch (tag) { case TagResources.LoginHistorySearch: this.gcLoingHistoryGrid.SafeInvoke(d => d.DataSource = null); MySqlManage crud = new MySqlManage(ConfigurationManager.ConnectionStrings["MySQL"].ConnectionString); string query = "select IQR03DAT, IQR03AID, IQR03MNO from amr_iqr03"; DataSet ds = new DataSet(); ds = crud.SelectMariaDBTable(crud.Connection, query); this.gcLoingHistoryGrid.DataSource = ds.Tables[0]; break; case TagResources.ContactNew: break; } }
/// <summary> /// 테이블 기본값 입력 /// </summary> void InitGridData() { this.gridControl1.SafeInvoke(d => d.DataSource = null); crud = new MySqlManage(ConfigurationManager.ConnectionStrings["MySQL"].ConnectionString); string query = "select MST04SNO, MST04DON, MST04HNO from amr_mst04"; DataSet ds = new DataSet(); ds = crud.SelectMariaDBTable(crud.Connection, query); foreach (DataRow row in ds.Tables[0].Rows) { mDataTable.Rows.Add(row[0], DateTime.Now.ToString("yyyy-MM-dd hh"), row[1], row[2], "null", "null", "null", "null", "null", "null", "null"); mCommTable.Rows.Add(row[0], DateTime.Now.ToString("yyyy-MM-dd hh"), row[1], row[2], "null", "null", "null", "null", "null", "null", "null"); } //gridControl1.DataSource = mSensorInfoTable; gridControl1.DataSource = CreateData(); }
protected override void InitMDBData(string connectionString) { MariaDbConnection = new MySqlConnection(connectionString); MariaDbConnection.Open(); MySqlManage sql = new MySqlManage(ConfigurationManager.ConnectionStrings["MySQL"].ConnectionString); DataSet ds = new DataSet(); ds = sql.SelectMariaDBTable(MariaDbConnection, "SELECT * FROM AMR_MST06"); foreach (DataRow row in ds.Tables[0].Rows) { UserInfo contact = new UserInfo(); contact.Id = row["MST06AID"].ToString(); if (row["MST06LEV"].ToString() == "1") { contact.Level = UserLevel.Level1; } else if (row["MST06LEV"].ToString() == "2") { contact.Level = UserLevel.Level2; } else if (row["MST06LEV"].ToString() == "3") { contact.Level = UserLevel.Level3; } contact.Name = row["MST06NAM"].ToString(); contact.Phone = row["MST06PHN"].ToString(); contact.Password = row["MST06PWD"].ToString(); contact.ConfirmPassword = row["MST06PWD"].ToString(); DataHelper.UserInfos.Add(contact); } gidControlUserManage.DataSource = DataHelper.UserInfos; }