Description:
my e_mail mikhail@ua.fm
Sorry for my bad english..
I have there are some tables, for example:
create table IF NOT EXISTS zvan (id int(8) primary key unique auto_increment, name varchar(250)) TYPE=INNODB
create table IF NOT EXISTS ljudyna (id int(8) primary key unique auto_increment, name varchar(250), data_narod date, id_in_zvan int(8), kandidat varchar(250), tel_rob_vn varchar(250), tel_rob_mis varchar(250), n_kabin varchar(250), n_nak_zvan varchar(250), d_nak_zvan date, sex tinyint(1), n_nak_pos varchar(250), d_nak_pos date, posad_data varchar(250), visl1 varchar(250), visl2 varchar(250), visl3 varchar(250), cpidr_f int(8), cposad_f int(8), sumis tinyint(1), zs_s date, zs_po date, ovs_z date, ovs_po date, naiavn_zviln tinyint(1), ovs_z1 date, ovs_po1 date, ovs_z2 date, ovs_po2 date, ovs_z3 date, ovs_po3 date, ovs_prakt varchar(250), data_atest date, data_sp date, v_akad_z date, z_akad_zvln tinyint(1), v_akad_period varchar(250), nauk_stup varchar(250), vch_zvan varchar(250), n_sprav varchar(250), n_posv varchar(250), nacional varchar(250), osvita varchar(250), osvita_zakin_sho varchar(250), osvita_zakin_koli date, osvita_special varchar(250), osvita_kvalifikac varchar(250), de_navchaet varchar(250), data_vstupu date, termin_navch varchar(250), adresa varchar(250), tel_dom varchar(250), marka_avto varchar(250), n_avto varchar(250), color_avto varchar(250), vikor_avto varchar(250), posv_avto varchar(250), marka_zbr varchar(250), nomer_calibr_zbr varchar(250), vid_zbr varchar(250), nomer_data_razreshen varchar(250), pasport varchar(250), oklad1 varchar(250), prem07_2003 varchar(250), nadb07_2003 varchar(250), osob_nom varchar(250), nadbavka_stag_max varchar(250), nadbavka_stag_08_2003 varchar(250), nadbavka_stag_10_2003 varchar(250), nadbavka_stag_11_2003 varchar(250), nadbavka_stag_02_2004 varchar(250), vidp_vikoristav varchar(250), vidp_plan varchar(250), vidp_vidgil varchar(250), vidp_nevidgil_dniv varchar(250), nadb111 varchar(250), prem_3_1 varchar(250), nadb_4_1 varchar(250), prem_3_2 varchar(250), nadb_3_2 varchar(250), nedolos varchar(250), sposl int(8), cposl int(8), czaoh int(8), 07_2003_oklad varchar(250), 05_2003_oklad varchar(250), deti_jeni varchar(250), nadb_volny varchar(250), prem_volny varchar(250), dispanser tinyint(1), posl_spisok tinyint(1), anketa_avtobiogr tinyint(1), photokartka tinyint(1), sp1 tinyint(1), inshe varchar(250), oklad2 varchar(250), slugbova tinyint(1), atestuvan varchar(250), 09_2004_oklad_vstan varchar(250), golosuvannia varchar(250), stag_kalendar varchar(250), data_stag_kalendar varchar(250), medali varchar(250), medali_mae varchar(250), visluga_cal_ovs_and_zs varchar(250), FOREIGN KEY (id_in_zvan) REFERENCES zvan(id) ON DELETE CASCADE ON UPDATE CASCADE) TYPE=INNODB DEFAULT CHARACTER SET cp1251 COLLATE cp1251_ukrainian_ci
mysql-connector-net-1.0.0-beta work with this tables correctly, behind exception with COLUMN of DATE TYPE with values "0000-00-00"... Therefore I downloaded Version 1.0.2-gamma... and has collided the following problem:
Even your example (Table Editor) gives out the message on a mistake when i use dataadapter.fill method for my large table...
I quote the text of the message:
!************************************************************!
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
System.NullReferenceException: Object reference not set to an instance of an object.
at MySql.Data.MySqlClient.CommandResult.Load()
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at TableEditor.Form1.tables_SelectedIndexChanged(Object sender, EventArgs e) in j:\Program Files\mysql\MySQL Connector Net 1.0.2\samples\Table Editor\cs\Form1.cs:line 313
at System.Windows.Forms.ComboBox.OnSelectedIndexChanged(EventArgs e)
at System.Windows.Forms.ComboBox.WmReflectCommand(Message& m)
at System.Windows.Forms.ComboBox.WndProc(Message& m)
at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
************** Loaded Assemblies **************
mscorlib
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.573
CodeBase: file:///j:/windows/microsoft.net/framework/v1.1.4322/mscorlib.dll
----------------------------------------
TableEditor
Assembly Version: 1.0.1806.20252
Win32 Version: 1.0.1806.20252
CodeBase: file:///J:/Program%20Files/mysql/MySQL%20Connector%20Net%201.0.2/samples/Table%20Editor/cs/bin/Debug/TableEditor.exe
----------------------------------------
System.Windows.Forms
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.573
CodeBase: file:///j:/windows/assembly/gac/system.windows.forms/1.0.5000.0__b77a5c561934e089/system.windows.forms.dll
----------------------------------------
System
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.573
CodeBase: file:///j:/windows/assembly/gac/system/1.0.5000.0__b77a5c561934e089/system.dll
----------------------------------------
System.Drawing
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.573
CodeBase: file:///j:/windows/assembly/gac/system.drawing/1.0.5000.0__b03f5f7f11d50a3a/system.drawing.dll
----------------------------------------
System.Xml
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.573
CodeBase: file:///j:/windows/assembly/gac/system.xml/1.0.5000.0__b77a5c561934e089/system.xml.dll
----------------------------------------
MySql.Data
Assembly Version: 1.0.2.18525
Win32 Version: 1.0.2.18525
CodeBase: file:///J:/Program%20Files/mysql/MySQL%20Connector%20Net%201.0.2/samples/Table%20Editor/cs/bin/Debug/MySql.Data.DLL
----------------------------------------
System.Data
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.573
CodeBase: file:///j:/windows/assembly/gac/system.data/1.0.5000.0__b77a5c561934e089/system.data.dll
----------------------------------------
************** JIT Debugging **************
To enable just in time (JIT) debugging, the config file for this
application or machine (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.
For example:
<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>
When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the machine
rather than being handled by this dialog.
!************************************************************!
When I fill tables with smaller number of columns all works properly...
How to repeat:
always
Description: my e_mail mikhail@ua.fm Sorry for my bad english.. I have there are some tables, for example: create table IF NOT EXISTS zvan (id int(8) primary key unique auto_increment, name varchar(250)) TYPE=INNODB create table IF NOT EXISTS ljudyna (id int(8) primary key unique auto_increment, name varchar(250), data_narod date, id_in_zvan int(8), kandidat varchar(250), tel_rob_vn varchar(250), tel_rob_mis varchar(250), n_kabin varchar(250), n_nak_zvan varchar(250), d_nak_zvan date, sex tinyint(1), n_nak_pos varchar(250), d_nak_pos date, posad_data varchar(250), visl1 varchar(250), visl2 varchar(250), visl3 varchar(250), cpidr_f int(8), cposad_f int(8), sumis tinyint(1), zs_s date, zs_po date, ovs_z date, ovs_po date, naiavn_zviln tinyint(1), ovs_z1 date, ovs_po1 date, ovs_z2 date, ovs_po2 date, ovs_z3 date, ovs_po3 date, ovs_prakt varchar(250), data_atest date, data_sp date, v_akad_z date, z_akad_zvln tinyint(1), v_akad_period varchar(250), nauk_stup varchar(250), vch_zvan varchar(250), n_sprav varchar(250), n_posv varchar(250), nacional varchar(250), osvita varchar(250), osvita_zakin_sho varchar(250), osvita_zakin_koli date, osvita_special varchar(250), osvita_kvalifikac varchar(250), de_navchaet varchar(250), data_vstupu date, termin_navch varchar(250), adresa varchar(250), tel_dom varchar(250), marka_avto varchar(250), n_avto varchar(250), color_avto varchar(250), vikor_avto varchar(250), posv_avto varchar(250), marka_zbr varchar(250), nomer_calibr_zbr varchar(250), vid_zbr varchar(250), nomer_data_razreshen varchar(250), pasport varchar(250), oklad1 varchar(250), prem07_2003 varchar(250), nadb07_2003 varchar(250), osob_nom varchar(250), nadbavka_stag_max varchar(250), nadbavka_stag_08_2003 varchar(250), nadbavka_stag_10_2003 varchar(250), nadbavka_stag_11_2003 varchar(250), nadbavka_stag_02_2004 varchar(250), vidp_vikoristav varchar(250), vidp_plan varchar(250), vidp_vidgil varchar(250), vidp_nevidgil_dniv varchar(250), nadb111 varchar(250), prem_3_1 varchar(250), nadb_4_1 varchar(250), prem_3_2 varchar(250), nadb_3_2 varchar(250), nedolos varchar(250), sposl int(8), cposl int(8), czaoh int(8), 07_2003_oklad varchar(250), 05_2003_oklad varchar(250), deti_jeni varchar(250), nadb_volny varchar(250), prem_volny varchar(250), dispanser tinyint(1), posl_spisok tinyint(1), anketa_avtobiogr tinyint(1), photokartka tinyint(1), sp1 tinyint(1), inshe varchar(250), oklad2 varchar(250), slugbova tinyint(1), atestuvan varchar(250), 09_2004_oklad_vstan varchar(250), golosuvannia varchar(250), stag_kalendar varchar(250), data_stag_kalendar varchar(250), medali varchar(250), medali_mae varchar(250), visluga_cal_ovs_and_zs varchar(250), FOREIGN KEY (id_in_zvan) REFERENCES zvan(id) ON DELETE CASCADE ON UPDATE CASCADE) TYPE=INNODB DEFAULT CHARACTER SET cp1251 COLLATE cp1251_ukrainian_ci mysql-connector-net-1.0.0-beta work with this tables correctly, behind exception with COLUMN of DATE TYPE with values "0000-00-00"... Therefore I downloaded Version 1.0.2-gamma... and has collided the following problem: Even your example (Table Editor) gives out the message on a mistake when i use dataadapter.fill method for my large table... I quote the text of the message: !************************************************************! See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ************** System.NullReferenceException: Object reference not set to an instance of an object. at MySql.Data.MySqlClient.CommandResult.Load() at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at TableEditor.Form1.tables_SelectedIndexChanged(Object sender, EventArgs e) in j:\Program Files\mysql\MySQL Connector Net 1.0.2\samples\Table Editor\cs\Form1.cs:line 313 at System.Windows.Forms.ComboBox.OnSelectedIndexChanged(EventArgs e) at System.Windows.Forms.ComboBox.WmReflectCommand(Message& m) at System.Windows.Forms.ComboBox.WndProc(Message& m) at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) ************** Loaded Assemblies ************** mscorlib Assembly Version: 1.0.5000.0 Win32 Version: 1.1.4322.573 CodeBase: file:///j:/windows/microsoft.net/framework/v1.1.4322/mscorlib.dll ---------------------------------------- TableEditor Assembly Version: 1.0.1806.20252 Win32 Version: 1.0.1806.20252 CodeBase: file:///J:/Program%20Files/mysql/MySQL%20Connector%20Net%201.0.2/samples/Table%20Editor/cs/bin/Debug/TableEditor.exe ---------------------------------------- System.Windows.Forms Assembly Version: 1.0.5000.0 Win32 Version: 1.1.4322.573 CodeBase: file:///j:/windows/assembly/gac/system.windows.forms/1.0.5000.0__b77a5c561934e089/system.windows.forms.dll ---------------------------------------- System Assembly Version: 1.0.5000.0 Win32 Version: 1.1.4322.573 CodeBase: file:///j:/windows/assembly/gac/system/1.0.5000.0__b77a5c561934e089/system.dll ---------------------------------------- System.Drawing Assembly Version: 1.0.5000.0 Win32 Version: 1.1.4322.573 CodeBase: file:///j:/windows/assembly/gac/system.drawing/1.0.5000.0__b03f5f7f11d50a3a/system.drawing.dll ---------------------------------------- System.Xml Assembly Version: 1.0.5000.0 Win32 Version: 1.1.4322.573 CodeBase: file:///j:/windows/assembly/gac/system.xml/1.0.5000.0__b77a5c561934e089/system.xml.dll ---------------------------------------- MySql.Data Assembly Version: 1.0.2.18525 Win32 Version: 1.0.2.18525 CodeBase: file:///J:/Program%20Files/mysql/MySQL%20Connector%20Net%201.0.2/samples/Table%20Editor/cs/bin/Debug/MySql.Data.DLL ---------------------------------------- System.Data Assembly Version: 1.0.5000.0 Win32 Version: 1.1.4322.573 CodeBase: file:///j:/windows/assembly/gac/system.data/1.0.5000.0__b77a5c561934e089/system.data.dll ---------------------------------------- ************** JIT Debugging ************** To enable just in time (JIT) debugging, the config file for this application or machine (machine.config) must have the jitDebugging value set in the system.windows.forms section. The application must also be compiled with debugging enabled. For example: <configuration> <system.windows.forms jitDebugging="true" /> </configuration> When JIT debugging is enabled, any unhandled exception will be sent to the JIT debugger registered on the machine rather than being handled by this dialog. !************************************************************! When I fill tables with smaller number of columns all works properly... How to repeat: always