Error Message : System.Data.OleDb.OleDbException: 'No value given for one or more required parameters.
private void textBox1_TextChanged(object sender, EventArgs e) { //Format(dateTimePicker1.Value, "mm/dd/yyyy"); if(comboBox1.Text == "ID") { OleDbDataAdapter da = new OleDbDataAdapter("select * from Spldetails where ID like '%" + textBox1.Text + "%' and Date >= ('"+(dateTimePicker1.Value.ToString("mm/dd/yyyy"))+ "') and Date <= ('" + (dateTimePicker2.Value.ToString("mm/dd/yyyy")) + "')", con); OleDbCommandBuilder build = new OleDbCommandBuilder(da); DataSet ds = new DataSet(); da.Fill(ds, "Spldetails"); dataGridView1.DataSource = ds.Tables["Spldetails"]; } if (comboBox1.Text == "Empid") { OleDbDataAdapter da = new OleDbDataAdapter("select * from Spldetails where EmpId like '%" + textBox1.Text + "%' and Date >= ('" + (dateTimePicker1.Value.ToString("mm/dd/yyyy")) + "') and Date <= ('" + (dateTimePicker2.Value.ToString("mm/dd/yyyy")) + "'))", con); OleDbCommandBuilder build = new OleDbCommandBuilder(da); DataSet ds = new DataSet(); da.Fill(ds, "Spldetails"); dataGridView1.DataSource = ds.Tables["Spldetails"]; } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)