public DataTable ProfileDelete(PL_ProfileCreation ObjPlProfile)
        {
            //ObjPlProfile.UserTypeId = UserTypeID;
            //ObjPlProfile.Ind = Ind;
            //ObjPlProfile.ItemId = ItemId;
            DataTable dt = new DataTable();

            // SqlDataAdapter da = new SqlDataAdapter();
            dt = ObjDlProfile.ProfileDelete(ObjPlProfile);
            return(dt);
        }
        public DataTable ShowProfile(PL_ProfileCreation ObjPlProfile)
        {
            DataTable dt = new DataTable();

            //  int i=0;
            try
            {
                cmd             = new SqlCommand("SpProfileCreation", con);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.AddWithValue("@Ind", ObjPlProfile.Ind);
                con.Open();
                SqlDataAdapter ad = new SqlDataAdapter(cmd);
                ad.Fill(dt);

                // cmd.ExecuteNonQuery();
                con.Close();
            }
            catch (Exception ex) { msg = ex.Message; }
            return(dt);
        }