Error while running update query for access database
<p>This is my code:</p>

<pre><code>OleDbConnection con = new OleDbConnection("provider=microsoft.jet.oledb.4.0;data source=" + Application.StartupPath + "/shoping mall.mdb");
                con.Open();
                OleDbCommand cmd = new OleDbCommand("update RecordofItems set RecordofItems.Bill_no = " + textBox1.Text + ", RecordofItems.Received_from = '" + textBox62.Text + "', RecordofItems.Item_Code = " + textBox2.Text + ", RecordofItems.Quantity = " + textBox32.Text + ", RecordofItems.Sale_Rate = " + textBox47.Text + " where Item_Name = '" + textBox17.Text + "'", con);
                int x = 0;
                x = cmd.ExecuteNonQuery();
                if (x &gt; 0)
                {
                    MessageBox.Show("record deleted" + x);
                }
                else
                {
                    MessageBox.Show("no record exixt");
                }
                con.Close();
</code></pre>

<p>I want to update selected columns in my "RecordofItems" table that has 10 columns but I want to update only 6 selected columns, when I run the query it shows error "no value for one or more required paremeter" What to do ? please help me as soon as you can.</p>
