判断DataReader是不是为空!

string connString = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=";
            connString += Server.MapPath("~/jinhai.mdb");
            OleDbConnection conn = new OleDbConnection(connString);
            string seStr = "select * from kehu where user_name like @user_name";
            OleDbCommand comm = new OleDbCommand(seStr, conn);
            string name = "%" + txtName1.Text.ToString().Trim() + "%";
            comm.Parameters.AddWithValue("@user_name", name);
            conn.Open();
            OleDbDataReader dr = comm.ExecuteReader();
            if (dr.HasRows)
            {
                myReapeter.DataSource = dr;
                myReapeter.DataBind();
            }
            else
            {
                this.Page.ClientScript.RegisterStartupScript(this.GetType(), "afsdgfdh", "alert('没有此客户的任何记录！');", true);
            }
            dr.Close();
            conn.Close();

转载于:https://www.cnblogs.com/pwqzc/archive/2005/12/31/308828.html