internal static CustomersAndAgents_DataSet_appData.TicketsRow Get_TicketRow(string OrignalPnr) { CustomersAndAgents_DataSet_appData ds = new CustomersAndAgents_DataSet_appData(); Table_Adapter_Ticket.FillBy_Ticket_Row_by_PNR_StoreProcedure(ds.Tickets, OrignalPnr); var gg = (from o in ds.Tickets where (o.PNR == OrignalPnr) select o).FirstOrDefault(); return(gg); }