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));
}