OleDbDataAdapter Fill方法性能不佳

如果您只需要一行,请尝试使用如下所示的数据读取器,您将需要调整数据库名称、字段列表等内容。

请注意,我将输出写入IDE输出窗口,因此在使用代码/数据尝试此操作时,请将其打开。

public partial class Form1 : Form
{
    private void button1_Click(object sender, EventArgs e)
    {
        int id = 0;
        if (int.TryParse(textBox1.Text, out id))
        {
            OleDbConnectionStringBuilder Builder = new OleDbConnectionStringBuilder();
            Builder.Provider = "Microsoft.Jet.OLEDB.4.0";
            Builder.DataSource = Path.Combine(Application.StartupPath, "Database1.mdb");

            using (OleDbConnection cn = new OleDbConnection(Builder.ConnectionString))
            {
                string selectStatement = "SELECT UserName, JoinMonth FROM Users WHERE Identifier = @Identifier";
                using (OleDbCommand cmd = new OleDbCommand { CommandText = selectStatement, Connection = cn })
                {
                    cmd.Parameters.Add(new OleDbParameter { ParameterName = "@Identifier", DbType = DbType.Int32, Value = id });
                    cn.Open();
                    OleDbDataReader dr = cmd.ExecuteReader();
                    if (dr.HasRows)
                    {
                        dr.Read();
                        Console.WriteLine("{0} - {1}", dr.GetString(0), dr.GetString(1));
                    }
                    else
                    {
                        Console.WriteLine("Not located");
                    }
                }
            }
        }
    }
}