'assuming a private connection named "prConn" has already established to Mysql server Function RegisteredUser(ByVal poioAccount As String, ByVal poioPasswd As String) As Boolean 'for the example data attached shuch a password is poioPasswd ="33" for poioAccount ="care1a" Console.WriteLine("-------------VARIABLES") sprShowVariables() Console.WriteLine("-------------CREATE TABLE") sprShowCreatetbl() Console.WriteLine("-------------") printoxazo(progID.ToString, poioAccount) Dim prhReturnValue As Boolean = False Dim prhColCounter As Integer Dim prhEpipedostr As String = "`επιπεδο`" Dim mySelectQuery As String = String.Format("SELECT *,MD5('{1}') AS mypassscrumbled FROM {2}.{3} WHERE `χρηστης`='{4}' AND `ειναιμεσα`={5}", _ prhEpipedostr, poioPasswd, progXristesDb, progXristesTbl, poioAccount, progID) Dim myCommand As New MySqlCommand(mySelectQuery, prConn) Dim prhRStemp As MySqlDataReader prhRStemp = myCommand.ExecuteReader() ' Always call Read before accessing data. If prhRStemp.Read() Then If prhRStemp.GetString("mypassscrumbled") = prhRStemp.GetString("passwd") Then progAccountName = poioAccount progEpipedoProsbasis = prhRStemp.GetInt32("επιπεδο") progXristisOnomateponimo = prhRStemp.GetString("επωνυμο") & " " & prhRStemp.GetString("ονομα") 'Problem here! {"Could not find specified column in results"} For prhColCounter = 0 To prhRStemp.FieldCount - 1 Debug.WriteLine(prhRStemp.GetName(prhColCounter)) If prhRStemp.GetName(prhColCounter) = "τμημα" Then progTmima = prhRStemp.GetString("τμημα") Exit For End If Next prhReturnValue = True End If End If If Not prhRStemp.IsClosed Then prhRStemp.Close() Return prhReturnValue End Function Sub printoxazo(ByVal poioPasswd As String, ByVal poioAccount As String) Dim prhQueryString As String = "" Dim prhTable As DataTable Dim prhDA As MySqlDataAdapter Dim prhCB As MySqlCommandBuilder Dim prhEpipedostr As String = "`επιπεδο`" prhTable = New DataTable prhQueryString = String.Format("SELECT *,passwd,επιπεδο,επωνυμο,ονομα,MD5('{1}') AS mypassscrumbled FROM {2}.{3} WHERE `χρηστης`='{4}' AND `ειναιμεσα`={5}", _ prhEpipedostr, poioPasswd, progXristesDb, progXristesTbl, poioAccount, progID) prhDA = New MySqlDataAdapter(prhQueryString, prConn) prhCB = New MySqlCommandBuilder(prhDA) prhDA.Fill(prhTable) 'DataGrid.DataSource = prhTable showxazo(prhTable) prhTable.Clear() prhDA.Dispose() prhCB.Dispose() End Sub Sub showxazo(ByRef workTable As DataTable) Dim column As DataColumn Dim row As DataRow Dim currentRows() As DataRow = _ workTable.Select(Nothing, Nothing, DataViewRowState.CurrentRows) If (currentRows.Length < 1) Then Console.WriteLine("No Current Rows Found") Else For Each column In workTable.Columns Console.Write(vbTab & column.ColumnName) If column.ColumnName = "ονομα" Then 'in order to see if (in this very moment) the program can identify column name Console.Write(vbTab & "χοχο") End If Next Console.WriteLine(vbTab & "RowState") For Each row In currentRows For Each column In workTable.Columns Console.Write(vbTab & row(column).ToString()) Next Dim rowState As String = _ System.Enum.GetName(row.RowState.GetType(), row.RowState) Console.WriteLine(vbTab & rowState) Next End If End Sub Private Sub sprShowCreatetbl() Dim prhQueryString As String = "" Dim prhTable As DataTable Dim prhDA As MySqlDataAdapter Dim prhCB As MySqlCommandBuilder prhTable = New DataTable prhQueryString = String.Format("SHOW CREATE TABLE `genika`.`χρήστες`") prhDA = New MySqlDataAdapter(prhQueryString, prConn) prhCB = New MySqlCommandBuilder(prhDA) prhDA.Fill(prhTable) 'DataGrid.DataSource = prhTable showxazo(prhTable) prhTable.Clear() prhDA.Dispose() prhCB.Dispose() End Sub {"Could not find specified column in results"} ----------------------------------------------OUTPUT------------------------------------ -------------VARIABLES Variable_name Value RowState auto_increment_increment 1 Unchanged auto_increment_offset 1 Unchanged automatic_sp_privileges ON Unchanged back_log 50 Unchanged basedir /usr/ Unchanged binlog_cache_size 32768 Unchanged bulk_insert_buffer_size 8388608 Unchanged character_set_client utf8 Unchanged character_set_connection utf8 Unchanged character_set_database utf8 Unchanged character_set_filesystem binary Unchanged character_set_results Unchanged character_set_server utf8 Unchanged character_set_system utf8 Unchanged character_sets_dir /usr/share/mysql/charsets/ Unchanged collation_connection utf8_general_ci Unchanged collation_database utf8_general_ci Unchanged collation_server utf8_general_ci Unchanged completion_type 0 Unchanged concurrent_insert 1 Unchanged connect_timeout 5 Unchanged datadir /var/lib/mysql/ Unchanged date_format %Y-%m-%d Unchanged datetime_format %Y-%m-%d %H:%i:%s Unchanged default_week_format 0 Unchanged delay_key_write ON Unchanged delayed_insert_limit 100 Unchanged delayed_insert_timeout 300 Unchanged delayed_queue_size 1000 Unchanged div_precision_increment 4 Unchanged engine_condition_pushdown OFF Unchanged expire_logs_days 10 Unchanged flush OFF Unchanged flush_time 0 Unchanged ft_boolean_syntax + -><()~*:""&| Unchanged ft_max_word_len 84 Unchanged ft_min_word_len 4 Unchanged ft_query_expansion_limit 20 Unchanged ft_stopword_file (built-in) Unchanged group_concat_max_len 1024 Unchanged have_archive YES Unchanged have_bdb NO Unchanged have_blackhole_engine NO Unchanged have_compress YES Unchanged have_crypt YES Unchanged have_csv YES Unchanged have_dynamic_loading YES Unchanged have_example_engine NO Unchanged have_federated_engine YES Unchanged have_geometry YES Unchanged have_innodb YES Unchanged have_isam NO Unchanged have_merge_engine YES Unchanged have_ndbcluster DISABLED Unchanged have_openssl DISABLED Unchanged have_ssl DISABLED Unchanged have_query_cache YES Unchanged have_raid NO Unchanged have_rtree_keys YES Unchanged have_symlink YES Unchanged hostname ilias-laptop Unchanged init_connect Unchanged init_file Unchanged init_slave Unchanged innodb_additional_mem_pool_size 1048576 Unchanged innodb_autoextend_increment 8 Unchanged innodb_buffer_pool_awe_mem_mb 0 Unchanged innodb_buffer_pool_size 8388608 Unchanged innodb_checksums ON Unchanged innodb_commit_concurrency 0 Unchanged innodb_concurrency_tickets 500 Unchanged innodb_data_file_path ibdata1:10M:autoextend Unchanged innodb_data_home_dir Unchanged innodb_doublewrite ON Unchanged innodb_fast_shutdown 1 Unchanged innodb_file_io_threads 4 Unchanged innodb_file_per_table OFF Unchanged innodb_flush_log_at_trx_commit 1 Unchanged innodb_flush_method Unchanged innodb_force_recovery 0 Unchanged innodb_lock_wait_timeout 50 Unchanged innodb_locks_unsafe_for_binlog OFF Unchanged innodb_log_arch_dir Unchanged innodb_log_archive OFF Unchanged innodb_log_buffer_size 1048576 Unchanged innodb_log_file_size 5242880 Unchanged innodb_log_files_in_group 2 Unchanged innodb_log_group_home_dir ./ Unchanged innodb_max_dirty_pages_pct 90 Unchanged innodb_max_purge_lag 0 Unchanged innodb_mirrored_log_groups 1 Unchanged innodb_open_files 300 Unchanged innodb_rollback_on_timeout OFF Unchanged innodb_support_xa ON Unchanged innodb_sync_spin_loops 20 Unchanged innodb_table_locks ON Unchanged innodb_thread_concurrency 8 Unchanged innodb_thread_sleep_delay 10000 Unchanged interactive_timeout 28800 Unchanged join_buffer_size 131072 Unchanged key_buffer_size 16777216 Unchanged key_cache_age_threshold 300 Unchanged key_cache_block_size 1024 Unchanged key_cache_division_limit 100 Unchanged language /usr/share/mysql/english/ Unchanged large_files_support ON Unchanged large_page_size 0 Unchanged large_pages OFF Unchanged lc_time_names en_US Unchanged license GPL Unchanged local_infile ON Unchanged locked_in_memory OFF Unchanged log OFF Unchanged log_bin ON Unchanged log_bin_trust_function_creators OFF Unchanged log_error Unchanged log_queries_not_using_indexes OFF Unchanged log_slave_updates OFF Unchanged log_slow_queries OFF Unchanged log_warnings 1 Unchanged long_query_time 10 Unchanged low_priority_updates OFF Unchanged lower_case_file_system OFF Unchanged lower_case_table_names 0 Unchanged max_allowed_packet 16776192 Unchanged max_binlog_cache_size 4294967295 Unchanged max_binlog_size 104857600 Unchanged max_connect_errors 10 Unchanged max_connections 100 Unchanged max_delayed_threads 20 Unchanged max_error_count 64 Unchanged max_heap_table_size 16777216 Unchanged max_insert_delayed_threads 20 Unchanged max_join_size 18446744073709551615 Unchanged max_length_for_sort_data 1024 Unchanged max_prepared_stmt_count 16382 Unchanged max_relay_log_size 0 Unchanged max_seeks_for_key 4294967295 Unchanged max_sort_length 1024 Unchanged max_sp_recursion_depth 0 Unchanged max_tmp_tables 32 Unchanged max_user_connections 0 Unchanged max_write_lock_count 4294967295 Unchanged multi_range_count 256 Unchanged myisam_data_pointer_size 6 Unchanged myisam_max_sort_file_size 2147483647 Unchanged myisam_recover_options OFF Unchanged myisam_repair_threads 1 Unchanged myisam_sort_buffer_size 8388608 Unchanged myisam_stats_method nulls_unequal Unchanged ndb_autoincrement_prefetch_sz 32 Unchanged ndb_force_send ON Unchanged ndb_use_exact_count ON Unchanged ndb_use_transactions ON Unchanged ndb_cache_check_time 0 Unchanged net_buffer_length 16384 Unchanged net_read_timeout 30 Unchanged net_retry_count 10 Unchanged net_write_timeout 60 Unchanged new OFF Unchanged old_passwords OFF Unchanged open_files_limit 1024 Unchanged optimizer_prune_level 1 Unchanged optimizer_search_depth 62 Unchanged pid_file /var/run/mysqld/mysqld.pid Unchanged port 3306 Unchanged preload_buffer_size 32768 Unchanged protocol_version 10 Unchanged query_alloc_block_size 8192 Unchanged query_cache_limit 1048576 Unchanged query_cache_min_res_unit 4096 Unchanged query_cache_size 16777216 Unchanged query_cache_type ON Unchanged query_cache_wlock_invalidate OFF Unchanged query_prealloc_size 8192 Unchanged range_alloc_block_size 2048 Unchanged read_buffer_size 131072 Unchanged read_only OFF Unchanged read_rnd_buffer_size 262144 Unchanged relay_log_purge ON Unchanged relay_log_space_limit 0 Unchanged rpl_recovery_rank 0 Unchanged secure_auth OFF Unchanged secure_file_priv Unchanged server_id 1 Unchanged skip_external_locking ON Unchanged skip_networking OFF Unchanged skip_show_database OFF Unchanged slave_compressed_protocol OFF Unchanged slave_load_tmpdir /tmp/ Unchanged slave_net_timeout 3600 Unchanged slave_skip_errors OFF Unchanged slave_transaction_retries 10 Unchanged slow_launch_time 2 Unchanged socket /var/run/mysqld/mysqld.sock Unchanged sort_buffer_size 2097144 Unchanged sql_big_selects ON Unchanged sql_mode Unchanged sql_notes ON Unchanged sql_warnings OFF Unchanged ssl_ca Unchanged ssl_capath Unchanged ssl_cert Unchanged ssl_cipher Unchanged ssl_key Unchanged storage_engine MyISAM Unchanged sync_binlog 0 Unchanged sync_frm ON Unchanged system_time_zone EEST Unchanged table_cache 64 Unchanged table_lock_wait_timeout 50 Unchanged table_type MyISAM Unchanged thread_cache_size 8 Unchanged thread_stack 131072 Unchanged time_format %H:%i:%s Unchanged time_zone SYSTEM Unchanged timed_mutexes OFF Unchanged tmp_table_size 33554432 Unchanged tmpdir /tmp Unchanged transaction_alloc_block_size 8192 Unchanged transaction_prealloc_size 4096 Unchanged tx_isolation REPEATABLE-READ Unchanged updatable_views_with_limit YES Unchanged version 5.0.38-Ubuntu_0ubuntu1-log Unchanged version_comment Ubuntu 7.04 distribution Unchanged version_compile_machine i486 Unchanged version_compile_os pc-linux-gnu Unchanged wait_timeout 28800 Unchanged -------------CREATE TABLE Table Create Table RowState System.Byte[] System.Byte[] Unchanged ------------- passwd ?????????????? ??????????????1 mypassscrumbled RowState 182be0c5cdcd5072bb1864cdee4d3d6e 1 ΠΛΗΡΟΦΟΡΙΕΣ System.Byte[] Unchanged