c# - Winform invalid attempt to read when no data is present -

c# - Winform invalid attempt to read when no data is present -

am new in wpf working on project , getting error invalid effort read when no info nowadays using code-

sqlconnection l_oconn=null; seek { l_oconn = new sqlconnection("data source=ashish;initial catalog=ireg;integrated security=true"); if (txt_userid.text == "" || txt_password.text == "") { messagebox.show("please come in id , password", "login error"); return; } else if (l_oconn.state == system.data.connectionstate.closed) ; { l_oconn.open(); } sqlcommand l_ocmd = new sqlcommand("select * emplogin", l_oconn); sqldatareader l_odr = l_ocmd.executereader(); int count = 0; while (l_odr.hasrows) { l_odr.read(); string id, password; id = l_odr.getvalue(0).tostring().trim(); password = l_odr.getvalue(1).tostring().trim(); if (id == txt_userid.text && password == txt_password.text) { count = count + 1; stregistration strpage = new stregistration(); this.navigationservice.navigate(strpage); } } l_odr.close(); if (count == 0) { messagebox.show("please come in valid id , password", "login error"); } } grab (exception ex) { messagebox.show(ex.message); } { if (l_oconn != null) { if (l_oconn.state == connectionstate.open) l_oconn.close(); l_oconn.dispose(); } }

you need read datareader @ to the lowest degree 1 time fetch rows datareader. alter code

while(l_odr.hasrows) { // logic }

to

while (l_odr.read()) { }

c# wpf