Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

Question

Hi,

When pressing the button for inserting the values from the combobox, datatimepicker and maskedtextbox in the database I get this error:

"Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done."

on

com.ExecuteNonQuery();

Can anybody help me please what is the cose for occurance of this error?

Thenks in advance.

Nel · Answer

Here is the commandtext: com.CommandText = "Insert into Avtobusi (Garbr, Brdog, Data_implem, Slika_rekl, Data_otstran_rekl, Sloboden) values ( ?, ?,?,?,?,?)"; com.Parameters.AddWithValue("@Garbr", comboBox1.SelectedItem); com.Parameters.AddWithValue("@Brdog", textBox1.Text); com.Parameters.AddWithValue("@Data_implem", dateTimePicker5.Value.Date); if (pateka == "") { MessageBox.Show("message"); button9.Focus(); } byte[] imageData = ReadFile(pateka); com.Parameters.Add("@Slika_rekl", OleDbType.LongVarBinary).Value = imageData; if (maskedTextBox1.Text != " . .") { com.Parameters.AddWithValue("@Data_otstran_rekl", DateTime.Parse(maskedTextBox1.Text)); } else { com.Parameters.AddWithValue("@Data_otstran_rekl", DBNull.Value); } com.Parameters.AddWithValue("@Sloboden", checkBox2.Checked);

Pravin Ghadge · Answer

can u show me ur access querry? This error may occur if u r trying to insert wrong value in datetime field. or text value in nu,ber field.

Satyapriya Nayak · Answer

Hi Nel, Try this... using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.OleDb; namespace Insert { public partial class Form1 : Form { string ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["dsn"]; OleDbCommand com; string str; //OleDbDataAdapter oledbda; //DataSet ds; //DataTable dt; public Form1() { InitializeComponent(); } private void btn_Insert_Click(object sender, EventArgs e) { OleDbConnection con = new OleDbConnection(ConnectionString); con.Open(); str = "insert into student values('" + comboBox1.SelectedItem + "','" + dateTimePicker1.Text + "','" + maskedTextBox1.Text + "')"; com = new OleDbCommand(str, con); com.ExecuteNonQuery(); con.Close(); MessageBox.Show("Records Successfuly Inserted"); } private void Form1_Load(object sender, EventArgs e) { comboBox1.Items.Add("a"); comboBox1.Items.Add("b"); comboBox1.Items.Add("c"); } } } Thanks

Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (3)