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