Loading

This is my code but result is null.

This is my code but result is null.

Shovan Saha

9y846Learn iOS Programming

Is any wrong here?

private void btnSearch_Click(object sender, EventArgs e)

{

con = new OleDbConnection(conString);

var query = "SELECT * FROM LalData " +

" WHERE " +

"SuspenceAccount = @suspenceAccount " +

"AND " +

"PaymentDate BETWEEN @startDate AND @endDate ";

con.Open();

OleDbCommand cmd = new OleDbCommand(query, con);

cmd.Parameters.AddWithValue("@startDate ", DbType.Date).Value =

dtpStartDate.Value.ToShortDateString();

cmd.Parameters.AddWithValue("@endDate ", DbType.Date).Value =

dtpEndDate.Value.ToShortDateString();

cmd.Parameters.AddWithValue("@suspenceAccount ", DbType.String).Value =

comboBox2.SelectedItem.ToString();

adapter = new OleDbDataAdapter(cmd);

adapter.Fill(dt);

dataGridView1.DataSource = dt;

dataGridView1.CurrentCell = dataGridView1.Rows[dataGridView1.Rows.Count - 1].Cells[0];

con.Close();

}

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Dharmraj Thakur9y ago
Accepted answer
Make sure you have created object of dt.
Use DateTime instead of Date (change also in database field).
Fire query in access and varify result.
con = new OleDbConnection(conString);
            var query = "SELECT * FROM LalData " +
            " WHERE " +
            "SuspenceAccount = @suspenceAccount " +
            "AND " +
            "PaymentDate BETWEEN @startDate AND @endDate ";
            con.Open();
            OleDbCommand cmd = new OleDbCommand(query, con);
            cmd.Parameters.AddWithValue("@startDate ", DbType.DateTime).Value = Convert.ToDateTime(dtpStartDate.Value);
            cmd.Parameters.AddWithValue("@endDate ", DbType.DateTime).Value = Convert.ToDateTime(dtpEndDate.Value);
            cmd.Parameters.AddWithValue("@suspenceAccount ", DbType.String).Value = comboBox2.SelectedItem.ToString();
            adapter = new OleDbDataAdapter(cmd);
            adapter.Fill(dt);
            dataGridView1.DataSource = dt;
            dataGridView1.CurrentCell = dataGridView1.Rows[dataGridView1.Rows.Count - 1].Cells[0];
            con.Close();
0
Rafnas T P9y ago
hi,
try changing as follows

var query = "SELECT * FROM LalData " +
" WHERE " +
"SuspenceAccount = @suspenceAccount " +
"AND " +
"( PaymentDate BETWEEN @startDate AND @endDate )";

0
Khaja Moizuddin9y ago
may i know in which line you are getting error.
0