Error in the coding

there is an error in code. i have taken DataTable to fill it with the query passed to oledb but it is showing ola.Fill(dt)-  No value given for one or more required parameters. kindly help with this code

e)

{

);

con.Open();

;

();

(strquery, con);

oda.Fill(dt);

(dt.Rows.Count > 0)

Response.Redirect(

+txtName.Text);

else

);

I suspect your OleDbDataAdapter is confused. Seems its searching for parameters.

I have tested it and it works fine on my machine.

Try to rewrite your code on the following way:

        OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=D:\\New folder12\\Desktop\\SWAPNALI\\Database3.mdb");
        OleDbCommand cmd = new OleDbCommand("Select * from Table1 WHERE Name=@username AND Password=@password",con);
        cmd.CommandType = CommandType.Text;
        cmd.Parameters.AddWithValue("@username", txtName.Text);
        cmd.Parameters.AddWithValue("@password", txtPwd.Text);
                
        OleDbDataAdapter oda = new OleDbDataAdapter(cmd);
        DataTable dt = new DataTable();
        con.Open();
        oda.Fill(dt);
        con.Close();

        if (dt.Rows.Count > 0)
            Response.Redirect("Home.aspx?name=" + txtName.Text);
        else
            Response.Redirect("Error.aspx");