Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public void Load_Acc()
- {
- string query = "SELECT id, Username, Password, Mobile, Email, LastCheck, State, F_Name FROM accounts;";
- Dictionary<int, Dictionary<string, object>> userDataDictionary = new Dictionary<int, Dictionary<string, object>>();
- try
- {
- using (MySql.Data.MySqlClient.MySqlConnection connection = new MySql.Data.MySqlClient.MySqlConnection(Program.connection("db_sql", "")))
- {
- connection.Open();
- using (MySql.Data.MySqlClient.MySqlCommand command = new MySql.Data.MySqlClient.MySqlCommand(query, connection))
- {
- using (MySql.Data.MySqlClient.MySqlDataReader reader = command.ExecuteReader())
- {
- int rowIndex = 0;
- while (reader.Read())
- {
- Dictionary<string, object> rowData = new Dictionary<string, object>();
- rowData["id"] = reader["id"];
- rowData["Username"] = reader["Username"];
- rowData["Password"] = reader["Password"];
- rowData["Mobile"] = reader["Mobile"];
- rowData["Email"] = reader["Email"];
- rowData["LastCheck"] = reader["LastCheck"];
- rowData["State"] = reader["State"];
- rowData["F_Name"] = reader["F_Name"];
- userDataDictionary[rowIndex] = rowData;
- rowIndex++;
- }
- }
- }
- }
- dataGridView1.DataSource = ConvertToDataTable(userDataDictionary).DefaultView;
- }
- catch (Exception ex)
- {
- MessageBox.Show("An error occurred: " + ex.Message);
- }
- }
- private DataTable ConvertToDataTable(Dictionary<int, Dictionary<string, object>> dictionary)
- {
- DataTable table = new DataTable();
- foreach (var innerDictionary in dictionary.Values)
- {
- if (table.Columns.Count == 0)
- {
- foreach (var columnName in innerDictionary.Keys)
- {
- table.Columns.Add(columnName);
- }
- }
- DataRow row = table.NewRow();
- foreach (var keyValuePair in innerDictionary)
- {
- row[keyValuePair.Key] = keyValuePair.Value;
- }
- table.Rows.Add(row);
- }
- return table;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement