public DataTable getplace() { List <IDbDataParameter> SetParameters = new List <IDbDataParameter>(); string SQLString = ""; SQLString = "SELECT * FROM item_place"; return(iOpneDB.SELECT(SQLString, SetParameters)); }
public DataTable getitem(string place) { OpenDB iOpneDB = new OpenDB(); List <IDbDataParameter> SetParameters = new List <IDbDataParameter>(); string SQLString = ""; SQLString = "SELECT * FROM item_withplace where item_place = @Itemplace"; SetParameters.Add(new SqlParameter("@Itemplace", place)); return(iOpneDB.SELECT(SQLString, SetParameters)); }