public void SelectBlob(MySQLConnection con) { try { con.Open(); MySQLCommand cmd = new MySQLCommand("select col1, col2 from `trntipos` where col1=3", con); //, `SerialNumberLastUsed` cmd.UsePreparedStatement = true; cmd.ServerCursor = true; cmd.Prepare(); MySQLDataReader reader = (MySQLDataReader)cmd.ExecuteReader(); while (reader.Read()) { getBLOBFile("output.jpg", reader, 1); } reader.Close(); cmd.Dispose(); con.Close(); } catch (Exception e) { if (con != null) { con.Close(); } throw e; } }
public void InsertBlob(MySQLConnection con) { try { con.Open(); MySQLCommand cmd = new MySQLCommand("INSERT INTO `trntipos`(col1, col2) values (?, ?)", con); //, `SerialNumberLastUsed` MySQLParameter p1 = new MySQLParameter("@col1", DbType.Int32); MySQLParameter p2 = new MySQLParameter("@col2", DbType.Binary); p2.Value = GetBinary(@"myblob.jpg"); p1.Value = 1; cmd.UsePreparedStatement = true; cmd.Parameters.Add(p1); cmd.Parameters.Add(p2); cmd.Prepare(); int affectedrows = cmd.ExecuteNonQuery(); cmd.Dispose(); con.Close(); } catch (Exception e) { if (con != null) { con.Close(); } throw e; } }
public int TestSelect(MySQLConnection con, bool useNew) { int affectedrows = 0; try { con.Open(); MySQLCommand cmd = new MySQLCommand("SELECT col1, col2, col3, col4 FROM `test_table`", con); if (useNew) { cmd.UsePreparedStatement = true; cmd.ServerCursor = true; cmd.Prepare(); } IDataReader reader = cmd.ExecuteReader(); MySQLCommand cmd1 = new MySQLCommand("SELECT col1, col2, col3, col4 FROM `test_table`", con); if (useNew) { cmd1.UsePreparedStatement = true; //cmd.ServerCursor = true; cmd.FetchSize = 10; cmd1.Prepare(); } while (reader.Read()) { affectedrows++; IDataReader reader1 = cmd1.ExecuteReader(); while (reader1.Read()) { affectedrows++; long s1 = reader1.GetInt64(0); string st1 = reader1.GetString(1); DateTime dt1 = reader1.GetDateTime(3); } reader1.Close(); long s = reader.GetInt64(0); string st = reader.GetString(1); DateTime dt = reader.GetDateTime(3); } reader.Close(); cmd.Dispose(); con.Close(); return(affectedrows); } catch (Exception e) { if (con != null) { con.Close(); } throw e; } }
public int InsertTest(MySQLConnection con, bool useNew) { try { con.Open(); MySQLCommand cmd; if (useNew) { cmd = new MySQLCommand("INSERT INTO `test_table` (col1, col2, col3, col4) values (?,?,?,?)", con); //, `SerialNumberLastUsed` cmd.UsePreparedStatement = true; cmd.ServerCursor = false; cmd.Prepare(); } else { cmd = new MySQLCommand("INSERT INTO `test_table`(col1, col2, col3, col4) values (@col1, @col2, @col3, @col4)", con); //, `SerialNumberLastUsed` } MySQLParameter p1 = new MySQLParameter("@col1", DbType.Int32); cmd.Parameters.Add(p1); MySQLParameter p2 = new MySQLParameter("@col2", DbType.String); cmd.Parameters.Add(p2); MySQLParameter p3 = new MySQLParameter("@col1", DbType.Int16); cmd.Parameters.Add(p3); MySQLParameter p4 = new MySQLParameter("@col4", DbType.DateTime); cmd.Parameters.Add(p4); int affectedrows = 0; for (int i = 0; i < count; i++) { p4.Value = DateTime.Now; p1.Value = i; p2.Value = "Registro nĂºmero " + i; p2.Size = p2.Value.ToString().Length; p3.Value = i * 10; affectedrows += cmd.ExecuteNonQuery(); } cmd.Dispose(); con.Close(); return(affectedrows); } catch (Exception e) { if (con != null) { con.Close(); } throw e; } }
public override IDbCommand GetCommand(IGxConnection con, string stmt, GxParameterCollection parameters, bool isCursor, bool forFirst, bool isRpc) { if (isRpc) { stmt = convertToMySqlCall(stmt, parameters); } MySQLCommand mysqlcmd = (MySQLCommand)base.GetCommand(con, stmt, parameters); if (preparedStmts && isCursor && !isRpc) { mysqlcmd.UsePreparedStatement = true; mysqlcmd.Prepare(); } return(mysqlcmd); }
public void Test(MySQLConnection con) { try { con.Open(); MySQLCommand cmd = new MySQLCommand("SELECT col1, col2, col3, col4 FROM `test_table`", con); //, `SerialNumberLastUsed` cmd.UsePreparedStatement = true; cmd.ServerCursor = true; cmd.Prepare(); MySQLCommand cmd1 = new MySQLCommand("SELECT col1, col2 FROM `test_table`", con); //SerialNumberID IDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { IDataReader reader1 = cmd1.ExecuteReader(); while (reader1.Read()) { Console.Write(reader1.GetInt32(0) + " "); Console.WriteLine(reader1.GetString(1)); } reader1.Close(); Console.Write(reader.GetInt32(0) + " "); Console.WriteLine(reader.GetString(1)); Console.WriteLine(reader.GetDateTime(3)); Console.WriteLine(reader.IsDBNull(2)); Console.WriteLine(reader.GetInt16(2)); Console.WriteLine(reader.IsDBNull(0)); } reader.Close(); cmd1.Dispose(); cmd.Dispose(); con.Close(); } catch (Exception e) { if (con != null) { con.Close(); } throw e; } }