public List <User> getvendoritemdetials(int vid) { CmdCAP = new SqlCommand(); CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@vid", SqlDbType.Int, 100, vid)); DsCAP = CommonDbFunctions.FillDataSet("sp_vendoritemdetials", CmdCAP); return(CommonDbFunctions.ConvertDStolist(DsCAP)); }