public DeliveryBoyReg Search() { // string q = "Select * from DBoyDetail"; SqlCommand cmd = new SqlCommand("SP_DBoySearch", connection.GetConnection()); cmd.Parameters.AddWithValue("@DBoyID", DBoyID); SqlDataReader sdr = cmd.ExecuteReader(); DeliveryBoyReg db = new DeliveryBoyReg(); while (sdr.Read()) { db.DBoyID = (int)sdr[0]; db.DBoyName = (string)sdr[1]; db.DBCity = (string)sdr[2]; db.DBNic = (int)sdr[3]; db.DBCountry = (string)sdr[4]; db.DBAddress = (string)sdr[5]; } sdr.Close(); return(db); }
public List <DeliveryBoyReg> ShowAll() { //string q = "Select * from DBoyDetail"; SqlCommand cmd = new SqlCommand("SP_DBoyDetailShowAll", connection.GetConnection()); SqlDataReader sdr = cmd.ExecuteReader(); List <DeliveryBoyReg> lst = new List <DeliveryBoyReg>(); while (sdr.Read()) { DeliveryBoyReg db = new DeliveryBoyReg(); db.DBoyID = (int)sdr[0]; db.DBoyName = (string)sdr[1]; db.DBCity = (string)sdr[2]; db.DBNic = (int)sdr[3]; db.DBCountry = (string)sdr[4]; db.DBAddress = (string)sdr[5]; lst.Add(db); } sdr.Close(); return(lst); }