Windows Application Error: OleDbCommand.Prepare method requires all parameters to have an explicitly set type

Hi ajitn4u,

Check the below example.

Code

using System;
using System.Data;
using System.Data.OleDb;
using System.Windows.Forms;

namespace _AccessDatabase
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        OleDbDataAdapter da;
        DataSet ds = null;
        BindingSource bsource = new BindingSource();
        public void BindData()
        {
            string str = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Users\\Dharmendra\\Desktop\\Test.accdb;Persist Security Info = False; ";
            OleDbConnection con = new OleDbConnection(str);
            OleDbCommand cmd = new OleDbCommand("select * from transDemand where IssueDate=@IssueDate order by AccNumber Desc", con);
            cmd.Parameters.Add("@IssueDate", OleDbType.Date).Value = datesearch.Value.ToString("MM/dd/yyyy");
            da = new OleDbDataAdapter(cmd);
            ds = new DataSet();
            OleDbCommandBuilder cmdbuild = new OleDbCommandBuilder(da);
            da.Fill(ds, "transDemand");
            bsource.DataSource = ds.Tables["transDemand"];
            dataGridView1.DataSource = bsource;
        }
        private void btnupdate_Click(object sender, EventArgs e)
        {
            DataTable dt = ds.Tables["transDemand"];
            this.dataGridView1.BindingContext[dt].EndCurrentEdit();
            this.da.Update(dt);
            BindData();
        }
        private void Form1_Load(object sender, EventArgs e)
        {
            BindData();
        }
    }
}

Screenshot