现在的位置: 首页 > 综合 > 正文

判断DataReader是不是为空!

2012年08月16日 ⁄ 综合 ⁄ 共 826字 ⁄ 字号 评论关闭
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();

抱歉!评论已关闭.