static void Main() { Application.EnableVisualStyles(); Application.SetCompatibleTextRenderingDefault(false); welcome_form form = new welcome_form(); Application.Run(form); //form.ShowDialog(); data_process _form = new data_process(); Application.Run(_form); //_form.ShowDialog(); }
public int Select(string table_name, string column_name, process_html_text_callback callback, data_process context) { int ret = 0; int _ret = 0; bool __ret; Int32 read_row_count; Int32 _row_count = 0; Int32 row_index = 0; Int32 _row_index; string query; MySqlCommand cmd; MySqlDataReader dataReader; string[] datas; string[] ids; do { if (column_name.Length == 0) { ret = -1; break; } if (this.OpenConnection() != true) { break; } query = "SELECT COUNT(*) FROM "; query += table_name; cmd = new MySqlCommand(query, connection); dataReader = cmd.ExecuteReader(); cmd.Parameters.Clear(); do { _ret = 0; try { __ret = dataReader.Read(); if (__ret == false) { _ret = -1; break; } } catch (MySqlException ex) { _ret = -1; //When handling errors, you can your application's response based on the error number. //The two most common error numbers when connecting are as follows: //0: Cannot connect to server. //1045: Invalid user name and/or password. System.Diagnostics.Debug.WriteLine(string.Format("execuate sql error {0} {1}\n", ex.Number, ex.Message)); } if (_ret < 0) { break; } _row_count = dataReader.GetInt32(0); }while(false); dataReader.Close(); this.CloseConnection(); row_index = 0; if (row_index >= _row_count) { break; } datas = new string[ROW_COUNT_ONCE]; ids = new string[ROW_COUNT_ONCE]; for ( ; ;) { if (row_index >= _row_count) { break; } if (this.OpenConnection() != true) { break; } query = "SELECT * FROM "; query += table_name; query += " "; query += "LIMIT "; query += row_index.ToString(); query += ","; if ((_row_count - row_index) < ROW_COUNT_ONCE) { read_row_count = _row_count - row_index; } else { read_row_count = ROW_COUNT_ONCE; } query += read_row_count.ToString(); query += ";"; cmd = new MySqlCommand(query, connection); dataReader = cmd.ExecuteReader(); cmd.Parameters.Clear(); _row_index = 0; for ( ; ;) { do { _ret = 0; try { __ret = dataReader.Read(); if (__ret == false) { _ret = -1; break; } } catch (MySqlException ex) { _ret = -1; System.Diagnostics.Debug.WriteLine(string.Format("execuate sql error {0} {1}\n", ex.Number, ex.Message)); } }while(false); if (_ret == -1) { break; } ids[_row_index] = dataReader["id"].ToString(); datas[_row_index] = dataReader[column_name].ToString(); _row_index += 1; } dataReader.Close(); this.CloseConnection(); for (Int32 i = 0; i < _row_index; i++) { _ret = callback(ids[i], datas[i].ToString(), context); if (_ret == STOP_DATA_BASE_PROCESS) { break; } } if (_ret == STOP_DATA_BASE_PROCESS) { break; } row_index += ROW_COUNT_ONCE;; } } while (false); return(ret); }