private void LoadDataGridViewUserInfor()
{
string query = "select * from SYS.V_DS_USER WHERE USERNAME NOT LIKE 'TESTADMIN'";
DataTable dataTable = OracleDataController.GetDataGridView(query);
dataGVShowUserInfor.DataSource = dataTable;
}
public static void LoadDataToGrid(DataGridView dgv, List <string> listOfColumns, string tableName)
{
OracleDataController.ConnectDB(OracleDataController.GetDBConnection());
var query = $"SELECT * FROM {tableName}";
dgv.DataSource = OracleDataController.GetDataGridView(query);
for (int i = 0; i < dgv.Columns.Count; i++)
{
dgv.Columns[i].HeaderText = listOfColumns[i].ToString();
}
}
public static void LoadDataToCombobox(ComboBox cbx, ComboBox cbxUpdate, string tableName, string valueName, string displayName)
{
OracleDataController.ConnectDB(OracleDataController.GetDBConnection());
var query = $"SELECT * FROM {tableName} WHERE LibraryTypeStatusID = 1";
if (tableName.Equals(TableConstants.LibraryTypeStatus))
{
query = $"SELECT * FROM {tableName}";
}
// Bind data to Combobox
var dt = OracleDataController.GetDataGridView(query);
cbx.DataSource = dt;
cbx.ValueMember = valueName;
cbx.DisplayMember = displayName;
cbxUpdate.DataSource = dt;
cbxUpdate.ValueMember = valueName;
cbxUpdate.DisplayMember = displayName;
}