"fatal error encountered during data " Exception in Mysql C#

Question

While executing cmd.Fill(ds, "dt"); Getting "fatal error encountered during data " Exception in C# code. Database using Mysql server. Can anyone help on this...

Laxmidhar Sahoo · Answer

hi display the code

Jignesh Kumar · Answer

Hi Sirisha, Please check below code for example. I think you are missing some thing, SqlConnection con; SqlDataAdapter adapter ; DataSet ds = new DataSet(); try { // create connection object and write connection con = new SqlConnection( "connetionString" ); // Write your SQL statement String query= "SELECT * FROM YourTableName ; con. Open (); adapter = new SqlDataAdapter(query, con); //fill the dataset using fill method adapter.Fill(ds); } catch (Exception ex) { con. Close (); } https://www.c-sharpcorner.com/uploadfile/61b832/sqldataadapter-fill-method/ https://www.aspsnippets.com/Articles/Fill-Populate-DataSet-using-SqlDataAdapter-in-C-and-VBNet.aspx

Jefferson S. Motta · Answer

look at this: Between connection.Open(); and command.ExecuteNonQuery(); I just added two lines like this: connection.Open(); MySqlCommand cmd = new MySqlCommand( "set net_write_timeout=99999; set net_read_timeout=99999" , connection); // Setting tiimeout on mysqlServer cmd.ExecuteNonQuery(); int numOfRecordsUpdated = command.ExecuteNonQuery(); https://stackoverflow.com/questions/2546115/mysql-exception-fatal-error-encountered-during-data-read

Sirisha K · Answer

I am using here SqlAdapter and used cmd.SelectCommand.CommandTimeout = 99999; Whatever your provided link showing page not found

Rajanikant Hawaldar · Answer

The workaround then was to customize the net_xxx_timeout settings. For example, issue the following after openning your connection and before executing the datareader: https://stackoverflow.com/questions/17981953/fatal-error-encounterd-when-using-mysqldatareader https://bugs.mysql.com/bug.php?id=61807

"fatal error encountered during data " Exception in Mysql C#

Answers (5)