public List <Vitem> getvendorwiseitems(int vid) { CmdCAP = new SqlCommand(); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@vid", SqlDbType.Int, 100, vid)); DsCAP = CommonDbFunctions.FillDataSet("sp_vendortotitems", CmdCAP); return(CommonDbFunctions.convertitemstolist(DsCAP)); }