3
Answers

access database limiting query search to 73 records

Photo of Marvin kakuru

Marvin kakuru

3d
117
1

am writing web appliction and running select query from access database but the query is only returning 73 rows

below is the code am using.

 

public void listboxload()
        {
            OleDbConnection con = new OleDbConnection();
            con.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;" + @"Data source=" + Server.MapPath("bin/InfinitieBanking1.accdb") + ";Jet OLEDB:Database Password=Promise";
            
            con.Open();

            string searchvalue = TextBox1.Text.Trim();

            OleDbCommand cmd = new OleDbCommand("SELECT * FROM (SELECT * FROM Baacs)", con);
            //cmd.Parameters.AddWithValue("?", "%" + searchvalue + "%");
            OleDbDataAdapter da = new OleDbDataAdapter(cmd);
            DataTable dt = new DataTable();
            da.Fill(0, int.MaxValue, dt);


            dt.Columns.Add("DisplayText", typeof(string));

            Response.Write("loaded rows; " + dt.Rows.Count + "<br/>");

            foreach (DataRow row in dt.Rows)
            {
                string suic = row["suic"].ToString();
                string acnam = row["acnam"].ToString();

                row["DisplayText"] = string.Format("{0} - {1}", row["suic"], row["acnam"]);
            }

            ListBox1.DataSource = dt;
            ListBox1.DataTextField = "DisplayText";
            ListBox1.DataValueField = "suic";
            ListBox1.DataBind();

            
           
        }

Answers (3)

Next Recommended Forum