public DsMaster.INSCUSTOMERSRow GetInscustomersRowByFileNo(string fileno) { var tam = new DsMasterTableAdapters.INSCUSTOMERSTableAdapter { Connection = { ConnectionString = _constr } }; var dt = new DsMaster().INSCUSTOMERS; tam.FillByFILENO(dt,fileno); DsMaster.INSCUSTOMERSRow dr = null; if (dt.Rows.Count > 0) dr = dt[0]; return dr; }